App Spotlight: New Sage Business Cloud Accounting App on Make

Saraappsheet · 05-15-2023 10:31 AM

Hi

1. I need to automatically download my email attachments to a folder and extract the data to Excel. (supplier invoices)

2. 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?

dbaum

@Saraappsheet wrote:

download my email attachments to a folder

AppSheet can't do this. Try Apps Script.

@Saraappsheet wrote:

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.

@Saraappsheet wrote:

feed/upload the data to my sage system

The right tool depends what mechanisms that system offers--e.g., manual csv import, API.

Saraappsheet

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?

dbaum

@Saraappsheet wrote:

guide me how to do this in apps script

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.

@Saraappsheet wrote:

you mean the OCR method by AppSheet

No. In noting you could use AppSheet, I was alluding to Use data from Google Drive - AppSheet Help.

dbaum

@Saraappsheet wrote:

sage

FYI:

Automation process flow