Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Download PDFDownload PDF
Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Jessica Haas
/
April 6, 2016
Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

MIN
/
April 6, 2016
About the Episode
Episode Highlights
Meet our Guest
Episode Transcript

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Get the Report

Great, thank ya!

You can now access the content.
Oops! Something went wrong while submitting the form.
Blog

Here to Help: How to Manage Your Formstack Data in Google Sheets

Panelists
No items found.
Introduction
Introduction

Great, thank ya!

You can now access the content.
Download NowDownload Now
Oops! Something went wrong while submitting the form.

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

Panelists
No items found.
Infographic

Here to Help: How to Manage Your Formstack Data in Google Sheets

Learn how you can connect Formstack and Google Sheets to send your form submission data to specific Google spreadsheets for easy sharing and collaboration.
Download InfographicDownload Infographic

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

Collecting payments with online forms is easy, but first, you have to choose the right payment gateway. Browse the providers in our gateway credit card processing comparison chart to find the best option for your business. Then sign up for Formstack Forms, customize your payment forms, and start collecting profits in minutes.

Online Payment Gateway Comparison Chart

NOTE: These amounts reflect the monthly subscription for the payment provider. Formstack does not charge a fee to integrate with any of our payment partners.

FEATURES
Authorize.Net
Bambora
Chargify
First Data
PayPal
PayPal Pro
PayPal Payflow
Stripe
WePay
ProPay
Monthly Fees
$25
$25
$149+
Contact First Data
$0
$25
$0-$25
$0
$0
$4
Transaction Fees
$2.9% + 30¢
$2.9% + 30¢
N/A
Contact First Data
$2.9% + 30¢
$2.9% + 30¢
10¢
$2.9% + 30¢
$2.9% + 30¢
$2.6% + 30¢
Countries
5
8
Based on payment gateway
50+
203
3
4
25
USA
USA
Currencies
11
2
23
140
25
23
25
135+
1
1
Card Types
6
13
Based on payment gateway
5
9
9
5
6
4
4
Limits
None
None
Based on payment gateway
None
$10,000
None
None
None
None
$500 per transaction
Form Payments
Recurring Billing
Mobile Payments
PSD2 Compliant

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

"Here to Help" is a support column written especially for Formstack's awesome, loyal customers.

Do you spend a lot of time in Google Apps? If you work for one of the more than 2 million paying businesses that now use Google Apps for Work, probably so. Wouldn’t it be nice if you could view your Formstack submission data right in Google, where you’re already hanging out? Of course it would. And you can! Formstack syncs seamlessly with a number of Google Apps, including Google Sheets. Our Google Sheets integration lets you update Google spreadsheets in real time using form submission data from Formstack. With this connection, your data is instantaneously passed to a Google spreadsheet upon submission—so you can forgo logging into Formstack to view your submissions and simply view and share the data right in Google.Not sure how to set up this awesome integration? I’ve got you covered:

Step 1: Create the Form That Will Pass Data to Google Sheets

This might seem obvious, but before you can set up the integration, you have to build a form that can be connected to Google Sheets. For example, you can build a contact form that will send all collected contact information to a master Google spreadsheet.

Contact Form Built with Formstack

Step 2: Create the Google Spreadsheet That Will House Your Form Data

Once you’ve created your form, you’ll want to create the corresponding Google spreadsheet. To ensure your form and spreadsheet sync properly, each column header on your spreadsheet should correspond to a similar field label on your form. As you can see below, our spreadsheet header titles match the field labels on the form we created in step 1.

Connect Google Sheets with Formstack

Note: Don’t use only characters or numbers as the column titles in your Google spreadsheet, or the data will not populate properly into those columns.

Step 3: Connect Your Form to Google Sheets

Once your form and spreadsheet have been created, you’re ready to activate the integration. To integrate your Formstack form with Google Sheets, click on Settings > Integration Hub > Documents, and then select Add below Google Spreadsheets.  

Add Formstack Google Sheets Integration

This will add a Google Spreadsheets tab below the Integration Hub tab, and you will be immediately asked to provide your Google Account information in one of two ways:

  1. If you’ve already connected Google Spreadsheets to another form, you will be given the option to copy the authentication credentials from that form.
  2. If not, you will be asked to log in to Google Spreadsheets.
Connect Formstack to Google Account

If you choose to log in to your Google account, a new Google window will open that asks you to grant Formstack access to your account.

Allow Formstack to Access Your Google Account

Step 4: Map Your Form Fields to Your Spreadsheet Fields

Once you've allowed Formstack to access your Google Sheets, you will be directed back to the Formstack integration settings. There, you can choose the Google spreadsheet and specific worksheet you want to populate and map each field on your form to a column on your sheet.

Formstack Google Sheets Integration Settings

Once everything is properly matched, you will need to switch the integration to on under Run mode at the top of the screen.

Activate Formstack Google Sheets Integration

Step 5: View, Update, and Share Formstack Data in a Google Spreadsheet

If the setup is flawless, any data that is submitted to the linked form will automatically populate in the last available blank row in your spreadsheet, and you will be able to share this data with colleagues and others—even those who don’t have access to your Formstack account—right in Google.

Formstack Contact Form Example
Formstack Submission Data
Google Sheets Data from Formstack

If a submission fails to populate onto the linked spreadsheet, you can go directly into the submission in Formstack, click on it, and click the puzzle piece icon on the right to re-run the submission and send that data to your spreadsheet.

How to Rerun Formstack Google Sheets Integration

If you make any changes to the sheet in Google, you must refresh the spreadsheet and worksheet in the Formstack integration settings (via the green refresh arrows) to resync the sheet with your form submission data.

How to Refresh Google Sheet Sync in Formstack

Other Helpful Information

  • You cannot have more than one instance of the Google Sheets integration running at a time, and you cannot map to more than one sheet in a single form.
  • Google only allows a single username/password to be logged into their services up to 25 times. So if you have Google Sheets linked to 10 forms, you are using up 10 instances of the Google login.
  • Some common errors you may experience when setting up and using the Google Sheets integration are detailed in this Support doc.

Want to know more about connecting Formstack to your Google account? Click here to read about all our Google app integrations.

Jessica Haas
Jessica is the Director of CX & Professional Services at Formstack and has been with the company since 2012. Most of the time, her brain is consumed by thoughts of service design, customer happiness, and creative solutions. She wants to make a difference for people and hopes to someday become a master of zen.
More Articles
Meet The Host
CEO of
Connect
Chris is on a mission to turn people into great leaders. He's passionate about helping problem solvers see more value in the work they do every day.