Create Multiple Spreadsheet Rows in Google Sheets Puts everything in the same row

Question

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.

When using “Create Multiple Spreadsheet rows” this is how it would send the data to the Google Sheet. You can see it first reads all the data then outputs them as individual line items.
This is using Lookup Spreadsheet Rows

Troy Tessalone · Answer

Hi @myuillGood question.If you are trying to find/create + update, then you would need to use a different approach.There is no upsert (create/update) option for GSheets in the Zap action.Try using the Looping app to iterate thru each CSV record.https://zapier.com/apps/looping/help

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded