Hi! I need a chatbot to move receipts from messanger to Google Sheets. For examble, user write a link with receipt. AI defines a name, type of dish, type of meat. How can I move this data to sheets? how to extract it from ai answers?
Question
How to extract data from AI and move it to Google Sheets
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+6- Zapier Solution Partner
Hey
Your workflow should go something like this-
1. Messenger Trigger( Can be through 3rd party apps)
2. If its image or pdf, some kind of OCR step.
3. AI by Zapier
4. Send to Sheets
This is a simple flow and the complexity will depend on your exact workflow.
PS: If you need any professional help and a done for you service, I am a Zapier Official Silver Solution Partner and you can contact me through my solution page here or just send a DM from my profile :)
- Zapier Staff
Hey
You can set up a Chatbot to collect the lead’s data and drop that data into a Google Sheet: https://help.zapier.com/hc/en-us/articles/26931673926669-Collect-leads-with-Zapier-Chatbots.
Then, you can set up a Zap that triggers from Google Sheets, or even from Zapier Tables, since the data is saved by default in a Zapier Table, you can use this app for the Zap as well.
Extract the receipt information with an app like ChatGPT, PDF.co, etc, then send the extracted data back to the spreadsheet app of your choice. Here is a template you can use to get started: https://zapier.com/apps/google-sheets/integrations/google-sheets/1746228/analyze-images-with-chatgpt-and-send-to-google-sheets.
The AI by Zapier app does not support images at the moment, so this one would not work for this particular workflow. More on this app here: https://help.zapier.com/hc/en-us/articles/8496342944013-Use-AI-by-Zapier-to-analyze-and-return-data.
I hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.