Google Sheets
With the Google Sheets direct integration, it is now easy to integrate your forms. Currently, we support the following actions:

  • Add Row to Sheet

Show me how!

  1. In the form editor, go to After Submissions → Integrations & Webhooks

  1. Under Direct Integrations, click Google Sheets, and choose from the list of possible actions (currently just "Add Row to Sheet").

  1. Click the "Add Account +" Button to connect your Google Sheets account. This will open a login flow in a new window that will ask you to give permission for Paperform to connect to your Google Sheets account.

  1. Follow the prompts to complete setting up the action. The prompts will ask you for the following:
  • Sheet: Choose which sheet you would like to connect the form to.

NOTE: You must own the sheet you wish to use for your integration. Sheets shared with your Google account will not be available to use.

  • 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" to test out the action. If you're happy with the results, click "Create" to finish setting up the action. This will automatically be live for future submissions.

You can remove or rename your Google Sheets account at any time in your account settings.

Common Gotchas

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.

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 formula: {{ phone }}
  • Treated as plain text: '{{ phone }}

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

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.

Find out more

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