When a new Jot Form submission arrives I need it to build a new Google Sheet and put the contents of the JotForm in Row 2.
Here’s the error and screenshot:
Zapier had trouble retrieving custom fields from Google Sheets.
Best answer
Jot Form to Google Sheets, how hard can this be?
- Beginner
- 12 replies
Best answer by Troy Tessalone
Hi
Try this…
Select an actual Spreadsheet ID (instead of dynamically mapping) that should load the columns, then you can map the desired data points, then switch back to the dynamically mapped Spreadsheet ID.
Always be sure to TEST!
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 Expert
- 31326 replies
- Answer
Hi
Try this…
Select an actual Spreadsheet ID (instead of dynamically mapping) that should load the columns, then you can map the desired data points, then switch back to the dynamically mapped Spreadsheet ID.
Always be sure to TEST!
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.