BG BGDatabase Home Setup How To Use Video guides Example Breakdown Fields Export Import Data Binding Events Code Generation Addons

Google Sheets

← Back Service data source setup
  1. Log in to Google Console
  2. Select or create a project
  3. Enable GoogleSheets API if it's disabled. Wait several minutes after enabling API. ( Google's guide, search for sheets)
  4. Select Credentials , click on Create credentials and choose Service
  5. Optionally name the service and press Create
  6. Click on Next button on next page
  7. Click on Create key button, choose Json, click on Create and download file on your computer
  8. Open downloaded file in text editor and copy client_email and private_key attributes to datasource parameters
  9. Open up your spreadsheet in your browser, copy the URL, click on Retrieve from URL button, paste the URL and click on Parse button to fill Spreadsheet ID (alternatively read this article to learn how to obtain SpreadsheetID)
  10. Save settings
  11. Switch back to your browser and add service email to the list of authorized users for your spreadsheet
← Back to Google Sheets