Question:
Can we can import as well as export from google sheet?
Answer:
Yes, you can do the following with google sheet.
Automatic Import of E-commerce orders
Automatic import of Leads from Chatbot webviews
Automatic import of Landing page submissions
Chatbot Custom variables
For items 1 to 3, go to Utilities → Google Sheets
For item 4, go to Facebook & Instagram → Chatbotflow → Bot Sheets
For additional information, please refer below:
Can I export my Ecommerce Store orders to Google Sheet?
Yes, you can automatically insert every order on your Google sheet. Use the Google Sheet feature of MMIO. Just follow these steps:
Google Sheets ➡ Import New Google Sheet ➡ create a new Google sheet ➡ give editor access to MMIO system's email (fbmm-google-int@fb-marketing-master.iam.gserviceaccount.com) ➡ copy your Google Sheet's URL and paste on the Import form ➡ Next ➡ select Sheet ➡ select Ecom Orders as source ➡ select your Ecom store ➡ Ok
Can I import my Landing Page data submissions on Google Sheet?
Yes, you can automatically insert every Landing Page submissions on your Google sheet. Use the Google Sheet feature of MMIO. Just follow these steps:
Google Sheets ➡ Import New Google Sheet ➡ create a new Google sheet ➡ give editor access to MMIO system's email (fbmm-google-int@fb-marketing-master.iam.gserviceaccount.com) ➡ copy your Google Sheet's URL and paste on the Import form ➡ Next ➡ select Sheet ➡ select Landing Page Submissions as source ➡ select your Your landing page ➡ Ok
Can I import my Webview submission data to Google Sheet?
Yes, you can automatically insert every Webview Submissions on your Google sheet. Use the Google Sheet feature of MMIO. Just follow these steps:
Google Sheets ➡ Import New Google Sheet ➡ create a new Google sheet ➡ give editor access to MMIO system's email (fbmm-google-int@fb-marketing-master.iam.gserviceaccount.com) ➡ copy your Google Sheet's URL and paste on the Import form ➡ Next ➡ select Sheet ➡ select Webview Submissions as source ➡ select your Your webview form ➡ Ok
In addition, there is a hard limit at the number of Google sheets “Reads” and “Insert” actions per day per user.
Each UserInput consists of a read+ write action per cell… and if your Flow users a lot of UserInput that directly saves the value to Google Sheet, the hard limit would quickly ran out.
As a work around, what you can do is to temporarily save the UserInput data as a Custom variable (and don't enable the Google sheet).
And then, at the end of your flow, use the BotSheetAPI so finally save the saved the collected data by writing it as a Row on your Google sheet
That way, you Google sheet user will only use-up minimal read/write limits since it's only updating the Google sheet once per Flow survery