How to Integrate with Google Sheets?

I am trying to set up google sheets integration and I am receiving an authentication error when trying to authenticate my account.

Can you advise if I need to use my google account log in details or jotform log in details when authenticating?

Hi Julie,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

When setting up the Google Sheets integration and encountering an authentication error, you should use your Google account login details to authenticate the integration. This is because the integration connects your Jotform data directly to your Google Sheets, so it requires access to your Google account.

If you continue to experience issues, sometimes removing the Google Sheets integration and adding it back can resolve authentication or syncing problems.

Let us know if you need further assistance with this.

Give it a try and let us know how it goes.

Hi Julie,

You need to connect your Google Account when integrating with Google Sheets. You can import data to an existing Google Sheet using our Google Sheets Integration. Let me show you how to set that up. First, let's connect your Google account to the form:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. In the menu on the left, click on Integrations and select the Google Sheets integration.
3. Now, select Use an Existing Spreadsheet and click on Next.
4. Then, click on Authenticate and connect your Google account.

Then, let's set up the integration settings:

1. Once you connect your Google account, click on Add Action.
2. In the Select a Spreadsheet section, click on Select, and
3. Select your Google Spreadsheet in the window that opens and click on Select.
4. Scroll down, make sure Send Existing Submissions to the Sheet option is selected and click the on Save button at the bottom right of the settings. That’s it.

Once everything is set up, your existing submissions will be sent to your spreadsheet. Any new submissions to your form will also update your Google Spreadsheet automatically. Check out the screencast below to see how it'll work:

Let us know if you need any more help.