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..i...
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |