Question

How do I stop Zap from skipping rows when transferring Google Forms data to Google Sheets?

  • 15 April 2024
  • 4 replies
  • 23 views

HI i have  a ZAP that transfers the data from a google form to a google sheet and it works fine EXCEPT that its picking up an ID number from google forms?

That seems to making Zapier fill in row 29 (in this case) instead of simple the next row and therefore inserting gaps in the rows.

How do i make it simply append the the next row and not use this ID please?


4 replies

Userlevel 7
Badge +14

Hi @Aclarke 

GSheets will return the ID and Row, both will have the same values, which are the Row #.

 

Sounds like perhaps your GSheet may not be configured correctly, which is causing the row to be inserted below rows that have existing formulas or cell values.

Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Hi @Aclarke 

GSheets will return the ID and Row, both will have the same values, which are the Row #.

 

Sounds like perhaps your GSheet may not be configured correctly, which is causing the row to be inserted below rows that have existing formulas or cell values.

Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

I thought this too but this is from forms in the test section yet i cant select or find that as as item i can select in the action sections 

this is the data out but i cant see or remove/amend this anywhere i cant understand where is Zapier picking this up from to output it i honestly don't know

 

 

Userlevel 7
Badge +14

@Aclarke 

FYI: GForms can be automatically saved to a GSheet: https://support.google.com/docs/answer/2917686?hl=en

 

Check Row 524 in your GSheet and you should see data that was added by the Zap.

 

Reply