How to Integrate my form to Google sheet

  • lancasterdetroit2025
    Asked on April 10, 2025 at 6:09 AM
    then have that information added to a spreadsheet to track payments and track t-shirt sizes, donation amounts etc.
  • Danilo JotForm Support
    Replied on April 10, 2025 at 6:15 AM

    Hi Kim,

    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.

    How to Integrate my form to Google sheet Image 1 Screenshot 40 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.

    How to Integrate my form to Google sheet Image 2 Screenshot 51 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:

    How to Integrate my form to Google sheet Image 3 Screenshot 62 Let us know if you need any more help.

Your Answer