Paperform logo
ProductTemplatesPricingResources
ProductTemplatesPricingResources
Sign inTry Free

How do I integrate with Google Sheets?

Help Making Forms Integrations

Integrations

Adobe Creative Cloud App Integration OverviewCan I make an automatic phone call upon form submission?Can I send an SMS with Paperform?What are direct integrations?Does Paperform have an API?My direct integration isn't working, what do I do?How do I connect my Adobe account to Paperform?How do I connect my other apps to Paperform?How do I use Zapier?How do I integrate with Airtable?How do I integrate with Discord?How do I integrate with Klaviyo?How do I integrate with monday.com?How do I integrate with Notion?How do I remove a direct integration account?How do I use direct integrations?How do you turn off a direct integration?What are webhooks and how do I use them?How do I integrate with Campaign Monitor?How do I integrate with Constant Contact?How do I integrate with ConvertKit?How do I integrate with Drip?How do I integrate with Dropbox?How do I integrate with Help Scout?How do I integrate with Intercom?How do I integrate with Keap (Infusionsoft)?How do I integrate with Mailchimp?How do I integrate with MailerLite?How do I integrate with Meistertask?How do I integrate with Moosend?How do I integrate with Trello?How do I integrate with Zendesk?How do I integrate with Zoho CRM?Quick IntegrationsHow do I use Zapier Filters?How do I use Zapier Formatter?What is Make and how do I use it?What services do you integrate with?WordPress Plugin

Google Sheets

Our direct integration makes it easier than ever to connect Google Sheets with your forms!

Connect Google Sheets to Paperform

  1. In the Form Editor navigate to "After Submission" → "Integrations & Webhooks".
  2. Click on "Google Sheets" under the heading "Direct Integrations". Choose from the list of possible actions on the dropdown list provided.

An image showing the button to add new actions for a Google Sheets integration, which has the Google Sheets logo and a title with the text "Google Sheets".

  1. Click on "Add Account +" to connect your Google Sheets account, prompting a popup window to appear requesting you log in and give permission for Paperform to connect your Google Sheets account.

An image showing the pop-up required for connecting Google Sheets to Paperform.

  1. Once the popup window closes, your account will be successfully connected to Paperform!

You can remove or rename your Google Sheets account at any time in your account settings, but note this will also affect any forms using this integration connection.

Setting up an Integration Action

Our Google Sheets direct integration is built to be flexible around your use case, so we offer a number of different actions and functions.

Below you'll find an example of how to configure one of these actions.

Add Row to Sheet

This action will add a new row to your Google Sheets document when the form is submitted.

After setting up your Google Sheets connection for the action, complete the fields presented. The list of fields and what they do can be found below;

  • Drive - Choose which drive you'd like to view document listings from.

    • The available options are Don't use a specific Drive, and the drives your account has access to. The drives are listed by name.

  • Sheet - Choose which sheet you would like to connect the form to.

  • Worksheet - Choose the worksheet from the selected sheet to add the row to.

  • Columns - This will load the columns in the selected worksheet, and you can use the "+=" icon to the right of the input to map specific answers to the columns into the spreadsheet.

Once you have finished configuring the action, click the "Send Test" button at the bottom to test out the action. If you're happy with the results, click "Finish Setup" to finish setting up the action. This will automatically be live for future submissions.

Considerations

Mapping data to columns

Some integrations like Google Sheets require you to create columns in the sheet before you can integrate with them. Once you have created the columns, you'll need to choose which answers go in each column. You can use the dropdown on the right of the column name to insert the answers you would like to go in each column.

An image showing an example of how the Colums section of a Google Sheets integration action may look. The screenshot also demonstrates how the dropdown menu to select fields on your form looks when populated with data.

If no columns appear in the list, you'll need to ensure that any columns you want to use contain a title in Row 1 of your Google Sheets document. You can then click the "Refresh" symbol to the right of this field to reload the column list.

Sending a Test for your action

For the "Send Test" button to work, you must have a recent submission that contains data for the fields being used in your integration action.

If you don't have a recent submission with the correct data set then you may encounter unexpected behaviors with integration action, or it may outright fail.

Gotchas

The data in Google Sheets shows up as #ERROR!

If you map data over to a column in Google Sheets that looks like it could be a formula, Sheets will try to parse it as a formula, which may result in some unexpected errors in cells.

To prevent this from happening and force Sheets to always treat the value as plain text (so, definitely not a formula) you can prepend the mapped value with a single quote — '.

Suppose you want to map a phone number question's answer over that typically is in the format +1 (xxx) xxx-xxxx with a key of {{ phone }}.

  • Treated as a formula: {{ phone }}
  • Treated as plain text: '{{ phone }}

Note the single quote, or apostrophe, before the answer piping.

Data is shifting right in the worksheet beyond specified columns

There are a number of things that may cause this. Primarily, we've found that keeping the integrated worksheet as plain as possible helps to prevent this issue.

Namely, we recommend against including:

  • formulas
  • graphs
  • checkboxes
  • dropdowns
  • gaps between column headings (empty data below a column heading is OK)
  • frozen rows and/or columns
  • formatting (hidden or visible)

That is, the integrated worksheet works best when it is kept as a place for raw data. Making any modifications or alterations to the connected Sheet, after it has been set up, may cause issues populating the data. If you wish to then transform, operate on, or visualize this data, we recommend using ImportRange from a sibling worksheet or another Sheet, depending on the desired usage.

Additionally, this issue may crop up if you have copied another form that had one or more integrations with Google Sheets.

Since you're copying the form and its configuration, the mapping for the action is also copied. When you then use a different worksheet, the copied mapping may remain, causing issues due to the inconsistency of column headings versus mapped data.

In the above instance, we recommend explicitly creating new actions on the form that is the copy to avoid running into inconsistent mappings that cause data to possibly shift right.

Reconnecting the Google Sheets Integration

Should you encounter difficulties with the submission data populating in your Google Sheet, please follow the steps below to resolve the issue:

  1. Disconnect the Google Sheets integration from your account by navigating to “Account Settings” → “Account Services”. Locate the Google Sheets integration and click the "delete" button to remove it.
  2. After disconnecting the integration, revisit the form's integration settings and reestablish the connection with your Google Account. To do this, click the “Add Account +” button and select the relevant account.
  3. Ensure that you save the changes by clicking the “Save Changes” button and activate the integration by toggling it on.

By following these guidelines, you should be able to effectively address any data submission issues and ensure a smooth integration between Paperform and Google Sheets.

If you have additional forms that were previously integrated with this Google account, kindly revisit each form and reactivate the integration. To do so, simply toggle the integration on the forms back to the "on" position.

What is Paperform?

Paperform is a web platform that enables anyone to create beautiful online forms, payment or product pages, quickly and intuitively, without any technical knowledge.

Want to be able to do more with Google Sheets? Let us know at support@paperform.co.

Related Articles

What are direct integrations?
Direct integrations on Paperform allow you to integrate directly between Paperform and numerous, popular services.
How much do direct integrations cost?
Direct Integrations have no additional fees or charges, so you'll just pay your Paperform subscription fee as usual.
How do I use direct integrations?
You can set up direct integrations in After Submission → Integrations & Webhooks from the form editor.
How do I remove a direct integration account?
Direct Integration accounts can be removed in your Account Settings.
How do I connect my other apps to Paperform?
There are several ways you can connect your forms with other apps; Direct Integrations, Zapier, Make (formerly Integromat), or if you are a developer - Webhooks.