Google Sheets integration: How can I specify which Google Sheets tab to populate?

SalArmyPhila
Asked 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

Jotform Support

Answered on March 04, 2021 at 04:06 PM

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.