Skip to main content
Question

GET Data from Google Sheet to Manychat

  • February 22, 2024
  • 4 replies
  • 294 views

Jim
  • Up-and-Comer

I want to transfer data from google sheet to custom fields as and when that data is updated (The data is coming from CRM). How do I get data from google sheet as and when it is created and/or updated? 

4 replies

Gustavo Boregio
Forum|alt.badge.img+6
  • Manychat Community Moderator
  • February 22, 2024

There are many ways to do it.

The easiest is probably to use Zapier - https://zapier.com/apps/manychat/integrations

You can use a trigger on your Google Sheet, and the Set Custom Field action on Manychat to update the information.

You can also use Make.com https://www.make.com/en/integrations/manychat with the ‘Set a Custom Field’ action.


Gustavo Boregio
Forum|alt.badge.img+6
  • Manychat Community Moderator
  • February 22, 2024

Or, you could add a loop in your Manychat account, to say check every hour or so if the Google Sheet has updated.

If you go down this route, be aware that you’ll have issues if you have many contacts or Google Sheets with many (thousands) of rows and data.


Jim
  • Author
  • Up-and-Comer
  • February 22, 2024

I was more of expecting not to use a third party application. But use Manychat to “Get Data” from Google Sheet


Gustavo Boregio
Forum|alt.badge.img+6
  • Manychat Community Moderator
  • February 22, 2024

Option 2 will work then ;)