Automated Reporting | MarquinSmith

Data Analysis

From email to data warehouse – Google Edition

4th July 20246th July 2024 M SmithLeave a comment

Use the Google technology stack to automatically load csv files received over email into BigQuery. In the data world, sending data over email is something that has been around for …

Business

Send a pdf attachment on email to Google Chat space

30th October 202330th October 2023 M SmithLeave a comment

Situation An pdf export is configured from some external system into your Gmail inbox. You take this pdf export, and forward it on to a Google Chat Space for wider …

Data Analysis

Automatically load CSVs received on email into Google Sheet

18th August 202318th August 2023 M SmithLeave a comment

When working hands on with data, the data can be in many different forms and in many different locations. The most common format is arguably csv format, and the most …

Data Analysis

Automating Google Analytics reports in Google Sheets

24th June 201724th June 2017 M SmithLeave a comment

This guide will walkthrough how to create automatically updating Google Analytics reports. This is for those who need to report on Google Analytics data regularly, and need to get access …