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.


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 …