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