Setup
You need to set up a couple of things before you can start extracting data from your Google Sheets.1
Authenticate
The first step is to authenticate with Google. You can do this by clicking the “Authenticate with Google” button.
Once you have authenticated, you will be redirected back to Less.
2
Spreadsheets
On the Spreadsheets tab, click the “Open Google File Picker” button. We unfortunately have to use Google’s own methodology for selecting spreadsheets.You can select multiple spreadsheets as long as your in the same directory/folder.
3
Sheets
In the final step, you’ll see each of your spreadsheets as expandable items. Once you expand an item, you can select the sheet you want to extract, the range you’d like to extract and the columns you’d like to extract. The range could for instance be “A4:B10” to skip the first 3 rows and extract the first 10 rows of the sheet in columns A and B.