My sheet has headers in row 1 and data filled through row 5. I’m using Zapier’s Create Spreadsheet Row to add new replies, but each new entry keeps landing in row 2. I want each new reply to go into row 6, then row 7, and so on. How can I force Zapier to append below row 5 instead of overwriting row 2?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- 34015 replies
Hi
Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help
- Make sure cell A1 has a value.
- Make sure there are no hidden rows/columns.
- Make sure there are no grouped rows/columns.
Hello
My first row (A) has column names and A1 cell has Serial number as value.
And the table has:
no hidden rows/columns and
no grouped rows/columns
+6- Zapier Staff
- 6780 replies
Hi
Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the Google Sheet action step in the CONFIGURE section that shows all of its fields.
Please don't include personal information in the screenshot, or be sure blur out any personal information.
Thanks!
+14- Zapier Orchestrator & Solution Partner
- 34015 replies
Also, include screenshots showing the top 3 rows of your GSheet.
sure,
Screenshot of the workflow:
Screenshot of google sheet configure section:
Screenshot of the first 3 rows of my google sheet:
+14- Zapier Orchestrator & Solution Partner
- 34015 replies
Try adding a value to the first column in the Zap step config.
+6- Zapier Staff
- 3527 replies
Hi
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.