Use 'Crawl Overview Importer' to upload to your sheet the crawl overview data from your web projects.

Using the sidebar you can input a .csv's URL stored in your server, the cloud or Google Drive and import periodically (monthly, weekly, dayly...) that information.

After this you can use all these data to make dashboards for you customers with Data Studio or Google Sheets.

The add-on has headings validation to ensure that the imported data matches with the columns wehere it will be stored. If the structure of csv files changes the importer will show you an error message.

The first time you import a .csv file on a sheets you get the Column Headings.

This is the imported data on this version:
-Date
-Total URLs Encountered
-Total URLs Crawled
-Total Internal URLs
-Total External URLs
-HTML
-JavaScript
-CSS
-Images
-PDF
-Blocked by Robots.txt
-Blocked Resource
-No Response
-Success (2xx)
-Redirection (3xx)
-Redirection (JavaScript)
-Redirection (Meta Refresh)
-Client Error (4xx)
-Server Error (5xx)
-Self Referencing
-Canonicalised
-Index
-Noindex

IMPORTANT : Screaming Frog© SEO Spider sets the field "Date" with the date when the .csv file was exported from the tool. If you want to match date field value with real crawl date you should export the same crawl day or change the date value when the .csv has been imported.