Help! .... create a "live" data reference from Gmail attachments

Ideas for how I can achieve dynamic database/spreadsheet that connects to a dashboard in AppSheet from a process where an attached delimited file is sent 3x/day to Gmail on a scheduled basis. How can i get each attached file to append to a “master” data source linked to AppSheet?

You can write a Google Apps Script to read the email’s attachment and append the data to a GSheet.

2 Likes

Looked for related info on Google App Scripts website and Community … can you point me to a specific reference that takes the Gmail attached delimited file and appends it to a designated Google Sheet?

Believe I’m getting closer … https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-1/index.html?index=..%2F..index#0

https://www.google.com/search?q=google+script+import+csv+email+attachment+to+google+sheet

3 Likes