Integrating Google Sheets

Being able to collect, track, and analyze your data is essential for any business. Using Google Sheets with Clepher, you can automatically create and edit spreadsheets with data from your chatbot.

What Google Sheets Actions and Fields are supported inside Clepher?

Supported Actions

Insert Row - Inserts a Row with desired data in your desired Google Sheet.
Delete Row - Deletes a Row in your Google Sheet.
Clear Row - Clears a Row in your desired Google Sheet.
Update Row - Updates a Row in your Google Sheet.
Fetch Row - Fetches a Row in your desired Google Sheet.
Insert Cell - Inserts a value in a cell in your desired Google Sheet.
Update Cell - Updates a value in a cell in your desired Google Sheet.
Retrieve Cell - Fetches a cell's value from your desired Google Sheet.

Supported Air Variable

Fetch Individual Cells - Fetches a cell from your Google Sheet.

Want to forward subscriber data like Email Addresses, Custom Fields, and more to Google Sheets? Simply use the personalization tag picker, point 'n click a couple of times... and data is transferred over to your spreadsheet where you can further automate everything you'd like.

How to Get Started with Google Sheets

To get started with Google Sheets, first, navigate to the Integrations page and click Create New, then select Google Sheets.

The connection form will ask you to authorize your Google Sheets Account

Finish the connection process by specifying a meaningful name for your integration.

You integrated Google Sheets, now what?

We’ve got an elaborate explanation of how to use Third Party integrations inside Clepher. You can find this article filed in the Automation Section.

Here are some ideas:

Enter text and Custom Fields into Google Sheets to manage your content.
Dynamic Carousels for Messenger (+ control every element of a carousel!)
Generate Dynamic Carousels as search results.
Show/hide content in Messenger by toggling the content status
Superfast performance for up to 25,000 rows of content.
Trigger Flows from Dynamic Carousels or links to external websites.
Create entire eCom apps for Messenger.
Add the power of Mathematics and Formulas to your Chatbot
And so much more… Let's continue with the supported fields.

Here are some tips:

If you want to pass a Custom Field, Messenger ID, or any other value tag as a string inside a formula in Google Sheets, you need to use quotations.

Ensure the values passed in formulas matches the target column(s) type in the specific google sheet, i.e. if the type of the column is plain text, then the values being passed need to be enclosed in "<value>" (double quotes), and if not being passed as formula then the doubles quotes can be skipped.
For numeric values, ensure they are within the size limits in Google Sheets.
For the messenger ID column, it is best to set it with plain text values so that conversion into another number format can be avoided.

Clepher Documentation