Google Sheets

  1. Go to Datasets / Add New / Connect Google Sheets
  2. To authorize Explorazor to access your Google Sheets click Authenticate
  3. Choose the account linked to Google Sheets
  4. To enable Explorazor to access your Google Account click Allow
  5. Click on Google Account to confirm nature of access granted to Explorazor as a Third Part App.
  6. Connect to the Google Sheet you want to extract data from by selecting it in the Spreadsheet Name field. Click on the dropdown to access the list of sheets available.
  7. Select the relevant worksheet and click Upload data
  8. Data retrieved from the Google Sheet selected will get stored under Datasets in Explorazor with the relevant timestamp reflecting the date and time of upload and refresh