AppsScriptPulse

Adding STAT Reports [extracting .csv email attachments] to Google Sheets Using App Scripts

Image credit: moz.com

The team at MacMillan Search has generated a lot of value by combining automated STAT reports with Google Sheets through the script they share in this post. From adding ranking details to other tool’s outputs to giving the content teams up-to-date “People Also Ask” reports, the end result has proven to be a great time-saver in our week-to-week SEO workflows by reducing manual work and providing standard outputs that easily integrate with any spreadsheet.

I always enjoy dipping into content from the SEO community as it has some really creative and innovative solutions. This example from MacMillian Search is a use case I’m familiar with, getting data out of a system as an email report with .CSV attachment and using Google Apps Script to do all the automation to update a Google Sheet. If you are not in SEO still worth a read as the pattern used here may come in handy.

Source: Adding STAT Reports to Google Sheets Using App Scripts

How to Automate Pagespeed Insights For Multiple URLs using Google Sheets – Moz

Calculating individual page speed performance metrics can help you to understand how efficiently your site is running as a whole.

In this post from James McNulty you can learn how to use Google Sheets and Google Apps Script to automatically check your website page speeds. As well as including everything you need to set this up James also shows how the results can be visualized in Data Studio

Source: How to Automate Pagespeed Insights For Multiple URLs using Google Sheets – Moz

Subscribe to AppsScriptPulse...