My problem is I can’t get individual rows imported in Google sheets, it imports everything into a single row with commas.
Here’s my current Zap:
- New attachment in Gmail
- Utilities in Formatter imports from CSV
- Lookup Spreadsheet Rows in Google Sheets
Originally step 3 was “Create Multiple Spreadsheet rows” and when using that, each row from the GMail CSV attacment would be imported into my Google Sheet into its own row.
However, the problem here was it would reimport old rows so rows were being entered twice, three times and more.
So I switched to Lookup Spreadsheet Rows in Google Sheets to use the “Create Google Sheets Spreadsheet Row if it doesn’t exist yet?” feature. Now it imports everything into a single row.
