Google Sheets Integration: Form submissions stopped syncing after initial entries

We are using this form since 2024 and it feeds the information into google sheets.

Tonight it stopped sending the data to google sheets. It has transferred 5 submissions and then just stopped.

I have tried to erase the previous entries in the sheet and submit new entries but nothing goes to the sheet. there is a second form that I am using to feed info into another tab in the same sheet and this form is not working as well.

Can you please

1. Help me understand what went wrong
2. How to make the form send the data it got to the sheet.
3. How to fix it without deleting and rebuilding the sheet, it is integrated to other sheets and I would like to avoid rebuilding the process that worked for the last two years.

Thanks,

Ron

Hi Ron,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

It's easy to re-integrate the Google Sheets integration. First, we’ll remove the existing Action. Let me show you how to do it:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.

2. Next, click on Integrations in the menu on the left.

3. Select the Google Sheets integration.

4. Then, hover over the Action section and click on the Three Dots icon on the right.

5. After that, select Delete Action from the dropdown menu that opens.

6. Now, click on Yes, Delete in the confirmation window that opens.

Now, let's connect the Google Sheets integration again. Here’s how to get going:

1. While in Google Sheet Integration settings, click on the Add New Action button.

2. Now, in the Choose an Action section, select either Create New Spreadsheet or Use Existing Spreadsheet, and then click on Next.

3. Next, in the Account dropdown, select your Google account, and then click on Authenticate.

4. Now, set up the Google Sheets settings, and then click on Save at the bottom.

If you select Create new spreadsheet, a new spreadsheet will be created in your Google account, where submissions will be collected. If you select Use existing spreadsheet, submissions will be collected in the spreadsheet you choose, which is already connected to your Google account.

We also have a guide about How to Integrate Forms With Google Sheets that you can check out.

Reach out again if you need any more help.

How can I make the current submissions transferred into google sheet without re-entering the data

Hi Ron,

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.

Can you help me understand what happened tonight that broke the integration that worked flawlessly for the last 2 years

Hi Ron,

Regarding what might have caused the Google Sheets integration to stop working after two years of flawless operation, here are some common reasons based on Jotform's integration behavior:

• Renaming column headings in Google Sheets can break the integration. If the column headers in your spreadsheet were changed, the integration may fail to map form fields correctly.
• Adding filters in Google Sheets may stop your spreadsheet from updating. If filters were applied, try reapplying or removing them to see if updates resume.
• Authentication or permission issues with your Google account can disrupt the connection. Sometimes re-authenticating the integration resolves this.
• Temporary network or server issues could cause the integration to fail in sending data.
• Changes in the Google Sheets file structure such as deleting or moving sheets or tabs can also cause the integration to stop working.

To troubleshoot, you can check the integration's Action Logs in Jotform, which display successful and failed runs and error messages. This can help identify the exact cause.

Also, ensure that the integration settings are intact and try re-authenticating or re-integrating if necessary.

If you want, I can guide you through checking the Action Logs or re-integrating the Google Sheets connection.

Let us know how you'd like to proceed.

Yes, show me the action logs

Hi Ron,

To check the Action Logs for your Google Sheets integration, you can follow these steps:

1. In Form Builder, click on Settings in the orange navigation bar at the top of the page.
2. Click on Integrations in the menu on the left.
3. Select the Google Sheets integration for your form.
4. Look for the Action Logs section, where you can see the history of successful and failed runs along with any error messages.

This log will help you identify what went wrong with the integration and why it stopped sending data.

If you need, I can guide you through re-integrating the Google Sheets connection as well.

Let us know if you want to proceed with that.

Hi Ron,

I’ve checked your form and can see that you’re still using the old version of the Google Sheets integration, which may be causing this issue.

Our Google Sheets integration has been updated and it now gives you the option to view the Activity Log. It would appear like this:

I’ve pushed the missing submissions from the Judge-Votes form and the Members-Votes x5 form to the integrated sheets. Can you check if you’re seeing them now? To prevent this from happening again, I suggest removing the existing integration and adding it again.

Let us know if there’s anything else we can help you with.

If your form stopped sending responses to Google Sheets, it’s usually because the connection between the form and the sheet was broken, responses were turned off, or permissions changed. Open your form, go to the Responses tab, and make sure it’s still linked to a spreadsheet and that “Accepting responses” is enabled; then check the sheet to confirm it hasn’t been deleted or renamed. If everything looks fine, try unlinking and reconnecting the sheet, and submit a test response to see if it appears—this often fixes the issue.

Google Sheets integration rukne ki wajah aksar expired permission, sheet structure change, ya automation OFF hona hota hai. Account dobara connect karein, columns check karein, aur agar Zapier ya koi aur tool use ho raha hai to usay ON karein. Apni site

par bhi form settings aur plugin configuration verify kar lein.