Tuesday, June 18, 2024

Google App Script

Warning, serious techie $#!& below!

Google App Script is a free (I love free) computer language that allows you to automate pretty much anything within the Google sphere of products, for example, Gmail, Calendar, Drive, Docs, Sheets, etc.  I recently set up a new Gmail account as the destination mailbox for reports that come in as compressed XML attachments.  Daily an App Script will run that processes all the emails in that inbox, decompresses the attachments in ZIP or GZ format, and them to Google Drive.  Subsequent scripts will parse that data and create CSV files which will be uploaded to a Google BigQuery database for querying and reporting.  

The code for reading the emails and saving the files is at the link below.  




No comments:

Post a Comment