Instructions for importing Projector report data into Google Sheets.

You can import your data into a Google spreadsheet by using Google's importData feature.

Make sure that you have a working report URL that is retrieving CSV
Add the querystring parameter dateformat=googledocs

Your final URL should look something like this:
https://app2.projectorpsa.com/report/code/variance?format=csv&UserName=YOUREMAIL&AccountCode=MYACCOUNTCODE&AuthToken=AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEEEEEEEE&columnheaders=firstrow&dateformat=googledocs
Test your URL by cutting and pasting it into your web browser. The browser should download a csv file.
Select the first cell in the Google Docs spreadsheet.
In the value field, enter the following, replacing "url" with your own URL

Google Spreadsheet

=importData("url")

Browser not supported