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

  • Profile Image
    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)?

    1614874553_604107b9bcf04_

    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

    Screenshot
  • Profile Image
    Laura_L
    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.