Hi
-
I need to automatically download my email attachments to a folder and extract the data to Excel. (supplier invoices)
-
I need to feed/upload the data to my sage system
How can I do this using AppSheet? anyone here can help me with this?
AppSheet can’t do this. Try Apps Script.
AppSheet could do this if you’re using Google Drive. However, if you’re already using Apps Script anyway that might be preferable.
The right tool depends what mechanisms that system offers–e.g., manual csv import, API.
1 Like
Hi thank you.. is there any way you can teach me or guide me how to do this in apps script?
extract the data to Excel
“AppSheet could do this if you’re using Google Drive. However, if you’re already using Apps Script anyway that might be preferable.”
in this scenario you mean the OCR method by AppSheet?
https://www.labnol.org/code/20009-convert-google-documents
Alternatives:
- Microsoft 365 provides its own APIs you could use from Apps Script.
- If you’re on the Microsoft platform generally, consider using Power Automate instead of Apps Script; it includes a Gmail connector.
No. In noting you could use AppSheet, I was alluding to Use data from Google Drive - AppSheet Help.