To store data results on Google Sheets you will need to generate a JSON key.
This is a one time process, on your next projects you will only need to load that file, share the sheet with the «rtila virtual user» and declare the sheet you want to use.
I’ll guide you step by step with the initial process to get the key.
Visit https://console.developers.google.com/
This is the welcome screen (maybe this is your very first time on the site).
Click on Agree and continue.
Click on Create Project button.
Give it a name and click CREATE button.
Click Library and search for Google Sheets API.
Click on it.
Click on Enable.
Go to the upper left hamburger menu and click on it.
Choose Credentials.
And click on Create Credentials.
Select Service account.
Give it a name, I used: RTILA, and press CREATE.
Click Done.
The service account is created, you can keep the service email, this will allow you sharing the sheet with this virtual service user.
Click on the pencil icon.
Move down and click Add Key.
Select Create new key.
A JSON file will be generated and downloaded to your computer.
This is a one time process, keep safe that key to reuse it on your projects.
All the steps above are needed just one time.
Configure a project
Now the following steps are needed each time you want to use Google Sheets.
STEP 1. Go to Google Sheets and create one Sheet.
Look at the URL, the sheet has a long string identifier (light blue on the image above), grab this string to use it later.
STEP 2. Share it with the user you generated before.
Click on Done.
STEP 3. Configure RTILA settings.
Select the JSON file and add the Spreadsheet ID on RTILA.
When you finish with the above settings, click the Save button.
Next, click on the Extractor button, the project results will be stored on RTILA local database and also on your Google Sheet.