Google Sheets integration allows you to take attributes collected in Chatfuel and store them in a spreadsheet. You can then organize this data in any way you want, use formulas and perform formatting tasks.
You can use Google Sheets to export:
first and last name;
locale or timezone;
any custom attribute you add to your Flow.
For example, you have a simple Flow where you ask users for their email. If you add a Google Sheet plugin to the end of that Flow, each time a new user leaves their email, your Google spreadsheet will be updated automatically.
How to use a Google Sheets integration
Before you can use a Google Sheets plugin you need to connect your Google account.
Connecting your Google account
To connect your Google account:
Go to Automation > Flows.
Create a new Flow or choose an existing one.
Add Send Data to Google Sheets plugin.
Click on the plugin (it should be highlighted in red).
Go to Select account > Connect Google account in the left side panel menu.
📌 Usually, you only need to connect your Google account once. You can also connect multiple accounts and switch between them.
Using Google Sheets plugin
After you've connected your Google account, you can choose what data to export and what spreadsheet to export it to.
First, add a spreadsheet you want to use. Although you can switch between spreadsheets, we recommend adding a new spreadsheet for each of your Flows.
Then, choose what attributes to export. You can perform a complete export or choose what attributes to export manually. Check 'Send all attributes' to export everything or add attributes manually one-by-one. You can then reorder attributes by drag-n-dropping them.