Easily send and store form data in it by integrating this service with Arengu, and start creating the database you need to get to know your users better. Learn how to integrate Google Sheets into your flows, without coding.
How to integrate Google Sheets
To send your form data to Google Sheets is as easy as adding the native action to a flow and configuring its settings. For example, we will include it in an after-submission flow, connected to a user qualification form.
To configure the action, click on it to open its settings and configure it action as follows:
- Connection. First, we need to connect a Google account via OAuth. Just click on the plus button and create a new connection or select an existing one.
- Spreadsheet ID. Get the spreadsheet ID from the URL of the spreadsheet in which you want to store the data and paste it in this field. https://docs.google.com/spreadsheets/d/{spreadsheetID}/edit#gid={sheetID}
- Sheet ID. Copy the sheet ID from the URL of the spreadsheet too and paste it in this field. If you don’t provide one, the default one will be used.
- Row values. Map the data that you will send to Google Sheets and the columns of the table in which each data will be stored. In the left column, include the name of the column in the Google Sheets spreadsheet and, on the right one, the variable that will be stored in it. You can get these variables by clicking on the plus button.
Send form data to Google Sheets
To send form input data to the spreadsheet, just click on the plus button of the corresponding field in the ‘Row values’ section to open the variables autocomplete menu.
The menu will show by default the data of the last execution of the flow although you can select another one. Under Executions > Input data, you will find all the input data from de form. Just click on the proper one to add it.
Send enriched data to Google Sheets
Under the Executions tab, you will also find the available variables from all the actions of the flow. For example, if you have included a data enrichment service like Clearbit, you can send the data enriched by this service to the spreadsheet.
You can also define custom variables with the ‘Store state variable’ action and recall them in the form and the following flows, in order to build advanced use cases. For example, to populate or autocomplete form fields, or to store the ID of a record to update its data.
You will find them under the ‘State’ tab of the variable autocomplete menu.
Out of the box integrations
In addition to Google Sheets, Arengu provides native actions to integrate with the most common services in signup and user qualification processes, allowing you to easily build automations in any stage of the form, and not only after form submission.
For example, you can easily generate, send and verify temporary codes with Mailjet, SendGrid or Twilio, or integrate Slack and Telegram to send custom notifications with the provided native actions. Plus, you can connect any service with an API using the HTTP Request action to build your own connections, so the possibilities are limitless.
Embed them anywhere
Arengu forms and flows are compatible with any tech stack. You just need to select the one to use and embed two simple lines of code. If you are using no-code services, you can check here how to embed them in Webflow and other landing page builders.
Haven’t you tried it yet? Sign up free or book a demo with our team.
