Registering a Google Sheet

In this article, you'll learn to register Google sheet for Botsheet API

BotsheetAPI is a tool that facilitates seamless integration between chatbots and Google Sheets. It empowers chatbots to retrieve, insert, update, and delete data directly from Google Sheets, enabling dynamic and real-time responses based on the information stored in the sheets.

It provides a straightforward and standardized approach to accessing data in Google Sheets, allowing chatbots to retrieve information without the need for complex data extraction processes or manual handling.

1. Go to Utilities > Bot Sheets

   

2. Click on Import New Google Sheet

   

3. Now, you'll need to create a Google Sheet and assign editor access to the email id: fbmm-google-int@fb-marketing-master.iam.gserviceaccount.com

   

4. Enter the Google Sheet URL that you have assigned to MMIO and click OK

   

   It'll take a few seconds and your google sheet import will be finished.

5. Congratulations, You have successfully imported your Google Sheet.