Google Sheets integration: How can I specify which Google Sheets tab to populate?
-
SalArmyPhilaAsked on March 04, 2021 at 11:25 AM
Good morning!
I currently have an integration with a Google Sheet; every JotForm submission creates a new row. However, since I have to create a new tab every month (by duplicating the newest tab, renaming, etc.), how can I keep the submissions going to the correct tab in the Sheet (A1/the tab furthest to the left)? Maybe a way to edit the "this spreadsheet" to reroute the submissions (as seen below)?
I figure the other way is to switch the tabs, but hoping not to resort to that. Any assistance/enlightenment is appreciated!
Thank you,
Brenda
-
Laura_LAnswered on March 04, 2021 at 04:06 PMJotForm Support
Hi Brenda,
Unfortunately through our integration, it is not possible to select specific tabs.
However, this should be possible with a Google Integration that is configured through Zapier:Please try the Zapier and see if you can configure the settings as you would want:
https://zapier.com/apps/jotform/integrations/google-sheets
Let us know if you have further questions.