Knowledge Base - Marketing Master IO

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

    image.png

  2. Click on Import New Google Sheet

    image.png

  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

    image.png

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

    image.png

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

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

    image.png