How to integrate my form with Google Sheets

HI- I am trying to create a jotform for an existing excel sheet on my drive that is already created. The sheet is for my workmen who needs live updates in the field when changes are made on my computer. I am having trouble connecting Jotform to excel. Kindly provide ALL the steps please so i can do it. I am using google drive at work.

Thanks in advance for your assistance.

Elvin

Hi Elvin,

Thanks for reaching out to Jotform Support. Can you explain more about what you want to happen? Are you trying to integrate your form with a Google Sheet that's in your Google Drive? If yes, then let me show you how to do this:

1. In Form Builder, click on Settings on the orange navigation bar at the top of the page.
2. Select Integrations from the left side window.
3. Select Google Sheets.
4. If you'll be using the spreadsheet in your Google Drive, select Use existing spreadsheet and click on Next.
5. Authenticate your Google Sheets account and click on Add Action.
6. Click on the Select button and select your existing spreadsheet.
7. Enter your preferred worksheet name.
8. Select the fields that you want to send to your Google Sheets.
9. Click on Save at the bottom of the page.

Note that a new sheet will be automatically created in your Google Sheets. Check out my screencast below:

To learn more, you can check out our guide on How to Integrate Forms with Google Sheets.

Let us know if you need any other help.