Connecting Google Sheets integration to my account

Hi, I just tried to connect the GOOGLE SHEETS integration to my account and it showed me an error message.

Now I don't know if it's really impossible to connect an integration directly with GOOGLE SHEETS because there could really be a glitch or because it's simply because I haven't made a paid subscription yet. I basically do see myself purchasing a paid subscription for this platform because after really many other platforms that I tried to work with I had a lot of glitches along the way, and here I was able to do things with a free subscription much better. The question is if I really purchase a paid subscription now, will it really open up access for me or will it continue to show that it's a technical glitch even after purchasing a subscription? (Because there might really be a technical glitch)

Thanks!

Hi Aviv,

Thanks for reaching out to Jotform Support. Could you provide us with more details about the issue so that we can assist you with resolving it? I have cloned one of your form and tested integrating Google Sheet and I didn't encounter any issues as shown in the screen recording.

If you can take a screenshot of what’s happening, that'll help us to understand better what’s going on. Let me show you how to post a screenshot to our Support Forum:

1. On the Support Forum page, scroll down to the Your Answer section and click on the Image icon.

2. Drag and drop your image into the Upload box, or click on it and select your file.

3. Then, click on the Add button in the bottom-right corner of the window.

4. To resize it, click on your screenshot and then click on one of the boxes in the corners, and drag it inward.

5. Once you're finished, click on the Post Answer button at the bottom right of the Your Answer section.

That's it. Once we hear back from you, we'll be able to help you with this.

Hi Aviv,

You are able to enter integrate your forms with Google Sheets under our Starter plan with no difficulties at all. I cleared your form's cache on my end as a form of basic troubleshooting. Clearing your form caches is one of the ways to refresh your forms. You can also try clearing your browser cache, these guides will show you how to do that: Google Chrome, Mozilla Firefox, and Safari. After that, try integrating the form to Google Sheets once more. We have a guide about How to Integrate Forms With Google Sheets that you might also want to check out.

Reach out again if you need any more help.

Hi. I clicked on "clear cache" on the website in google chrome, but it's still doesn't work and then I saw notification with links that says:

To get started, log in to your Google Sheets account. Next, create your form, customize it to your liking, and integrate it to start collecting responses in Google Sheets today.

Learn how to integrate your form with Google Sheets.

And the link: Learn how to integrate your form with Google Sheets

doesn't work me. The brower shows me this!

Hi Aviv,

Could you share with us a screen recording on how you integrate Google Sheet into your form using Loom so that we can get a better understanding on how the issue occurs on your side? As for the guide link, could you try accessing the English guide by removing he as shown in the screenshot.

Once we hear back from you, we'll be able to help you with this.

https://www.loom.com/share/499b015fbc44444a913a2fa7353380de?sid=84d450ee-54f2-46ca-95c9-5b006dc48ebc

That's my record link from loom!

I hope that it's work!

Hi Aviv,

Could you try integrating the Google Sheet into your form via the Form Builder page instead of the Google Sheet page? Here's how to do it:

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

2. Click on Integrations on the left side of the screen.

3. Select Google Sheets.

4. Select your Google account under Authentication.

5. Select Use an existing spreadsheet.

6. Click on the field under Spreadsheet name.

7. Select an existing Spreadsheet.

8. Click on Save.

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

https://www.loom.com/share/fe7b0566a9fd486494ebb271af5e3047?sid=0acd092b-4235-496c-89d4-f953d2490c28

So this time I changed the browser from GOOGLE CHROME to BRAVE in the hope that it would really solve the problem, but unfortunately it still causes problems and does not allow me to continue.

Hi Aviv,

Before we proceed with escalating this thread to our Developer Team. Could you grant us permission to access your account to test things out on our end? Let me show you how to do it:

1. In the upper-right corner of your My Forms page, click on your Avatar/Profile Image icon.

2. In the small window that opens, click on Settings.

3. In the panel on the left, click on the Security tab.

4. Then, on the bottom-right side of the page, toggle Jotform Support Access to the On position.

After we hear back from you, we’ll have a better idea of what’s going on and how to help.

Hi!

I opened the access!

Hi Aviv,

I accessed your account and created a Test Form to try to integrate it to Google Sheets, and I ran into the same issue, so I created a ticket and escalated it to our Developers. The error you are receiving results from insufficient authentication on your Google Account. Meaning that you have to either reauthenticate your personal computer/device/browser on your Google Account, or reauthenticate Jotform on your Google Account.

Another solution would be to make sure you have full access to the Google Sheets file you're trying to access. Check out this Google page for more information. You can also try to replicate the issue in incognito mode.

Give it a try and let us know if you need any other help.

Hi.

I have no idea how to do this. Can you explain it to me in steps or record a screen shot of exactly how to do it?

I'm just really confused by this!

Hi Aviv,

You can reauthenticate your account by logging in again with your Google account by clicking on Use another account as shown in the screenshot.

This will allow you to login to your Google account. If the issue still persists, we will let the Developer Team know of the result.

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

Hi!

Thank you very much, in good time I managed to bring the table from my GOOGLE SHEETS account, but there is another issue here now.

It now tells me under the file: There are no questions on your form.Add your first question

And it wants me to drag a question there. I didn't understand exactly how I can drag a question?

Hi Aviv,

I have checked your form#250444089235053 which you are trying to integrate, and this form does not have any fields which is why you are getting this message. Once you have added the fields to this form, you can proceed with the integration, and it will show all the fields that are available on the form.

Give it a try and reach out again if you have any other questions.

Hi!

The truth is that I could not understand what you meant by what you said:"Once you have added the fields to this form, you can proceed with the integration, and it will show all the fields that are available on the form."

Can you please show me on recording video or screenshot how does it happen?

Hi Aviv,

You are working on this form when integrating Google Sheet, as shown in your screenshot.

If you review the form under the Build tab, it is empty and does not contain any fields, which is why you have encountered the message that you have pointed out as shown in the screenshot.

You can start building your form by adding form elements. Here's how to do it:

1. In Form Builder, on the left side of the screen, click on Add Element.

2. On the left panel, click/drag any elements to add into the form.

Once you have done adding the elements into your form, you will no longer encounter the message that you have pointed out on your screenshot.

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

Ok. I did it right now but I still can't move on then

Hi Aviv,

May we know that fields you would like to map to your Google Sheet? It seems your form still has no fields in them. To add a field, let me show you how:

1. In Form Builder, click on the Add Element menu on the left side of the page.
2. Under the Basic tab, scroll down to the field you want to use, and drag and drop the field to your form.
   
   

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

Hi.

I filled in my full name and email address. Now I'm trying to click the "Send" button and it still doesn't work. Why isn't it working yet?

And can you show me everything I need so I can start working on the integration with GOOGLE SHEETS?

Hi Aviv,

To clarify, do you want to test your form? To test your form, you can click on the preview form. Let me show you how:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Preview form toggle on the right side of the page.
   
   

I would suggest you integrate your form first with Google Sheets and test it out. You can check out this guide on how to integrate the form with Google Sheets.

Give it a try and let us know if this works for you.

Hi.

I really want to start working with Google Sheets. Please, I would love for you to show me how to do it because I can't understand.

The video you sent me is how to connect an integration to Google Drive and I don't need it with Google Drive. Please, I've been trying to connect Google Sheets to your integration on the platform for 3 days.

I can't continue after I added the name and email to the form. How are you supposed to connect an integration to Google Sheets from here?

Please help me with this already!

Hi Aviv,

Once you have added your form fields, you can then integrate it to your Google Sheets. To integrate the form with Google Sheets, let me walk you through it:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. Click on Integration in the menu on the left side of the page.
3. Then click on Google Sheets.
   
   
4. Then in Authentication, select your Google Sheet account.
   
   
5. In Google Sheets, Choose an option select Use an existing spreadsheet then select the name. Once the set up is complete and click on Save at the bottom of the page.
   
   

You can check out this guide on how to integrate the form with Google Sheets.

Give it a try and let us know if this works for you.

Hi!

I'll explain exactly what I want to do here.

I have a Google Sheets spreadsheet that I'm interested in integrating with your platform.

This spreadsheet consists of destination points that I prepared and I'm interested in integrating it and adding a map so that the destination points that I saved in Google Sheets will be visible on the world map!

I would appreciate help on this subject because what I did now that I followed the screenshots referred to in section 5 that you mentioned, the questionnaire that I already prepared on the JOTFORM platform itself and it is almost ready and that's not what I meant.

I would appreciate help, please!

Hi Aviv,

To clarify, do you want to display the information from Google Sheets to the form you created? Unfortunately, the Google Sheet integration available in Jotform is only used to that submitted information from your form will be transferred to the sheets that you have. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Once we hear back from you, we'll be able to help you with this.

Hi.

I have destination points saved in my Google Sheets account (I've uploaded a screenshot here now).

I've also just opened a map in JOTFORM, and I already have a questionnaire that's almost completely ready, and I actually want the destination points I added to the map to appear to the user after the user answers the questionnaire (not all the destination points I do and will do, but only according to the area the user has selected).

Hi Aviv,

Are you trying to use the Google Sheets as a database and populate fields in the form based on the form user's answer? Keep in mind that the Google Sheets integration is a one way integration, meaning you can only send your data to your sheets. If you need something like a look-up tool, you can use the spreadsheet to form widget, which allows you to populate the form fields based on the uploaded file in the widget. If that's not exactly what you're looking for, you can provide us an example of what you're trying to achieve, so we can work on a solution.

Keep us updated and let us know if you need any more help.

Hi Aviv,

As for your other question, I've moved that to a new thread. You can check that out here.