How to Use Search Analytics in Google Sheets for Better SEO Insights - Moz | The MarTech Digest | Scoop.it
Simply put, Search Analytics for Sheets is a (completely free) Google Sheets add-on that allows you to fetch data from GSC (via its API), grouped and filtered to your liking, and create automated monthly backups.

If your interest is piqued, installing the add-on is fairly simple. Either install it from the Chrome Web Store, or:

  • Open a Google spreadsheet
  • Go to Add-ons -> Get add-ons
  • Search for Search Analytics for Sheets
  • Install it (It'll ask you to authorize a bunch of stuff, but you can sleep safe: The add-on has been reviewed by Google and no data is being saved/monitored/used in any other way except grabbing it and putting it in your spreadsheets).