Docs
  • LogicLoop Documentation
  • LogicLoop Quickstart
  • Data Sources
    • Connect your data source
      • Deployment options
    • Supported data sources
      • API data (JSON)
      • AWS CloudWatch
      • BigQuery
      • Databricks
      • Google Analytics
      • Google Sheets
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Snowflake
      • Combine Results
      • LogicLoop Data Source
  • Queries
    • Write a rule
      • More rule options
      • A/B testing rules
      • Version history
      • Query Snippets
    • Visualizations & dashboards
      • Visualizations
      • Dashboards
  • Actions
    • Set up an action
    • Action destinations
      • Email
      • Slack
      • Webhooks & APIs
      • Microsoft Teams
      • Salesforce
      • Zapier
      • PagerDuty
      • Write to Database
      • Chain Rules
      • Google Sheets
      • Bento
    • Templating
  • Case Management
    • Case Management
      • Ticket Generation
      • Case Triage
      • Custom Fields and Attachments
  • AI
    • AI Query Helper
    • Ask AI
  • Teams & Settings
    • Integrations
      • Slack
      • Google Sheets
    • Invite your teammate
    • Groups & Permissions
  • Changelog
  • FAQs
  • Troubleshooting
  • Templates
    • Templates Home
    • Risk & Fraud Rules
    • AML Transaction Monitoring Rules
    • Logistics & Marketplace Ops
    • Customer Success & Growth
    • Systems Observability
    • Data Quality Monitoring
    • Healthcare
    • HTML Email Templates
      • Annual Review
      • Weekly Performance Table
      • Invoice Recap
  • BETA
    • AI SQL API
    • Approving rules
    • Render Data as JSON
    • Case Analytics
    • Python
  • Security & Legal
    • Security
    • AI Security
    • Terms of use
    • Privacy policy
    • Services description
Powered by GitBook
On this page
  • Integrate Directly with Google Sheets
  • Reading your Google Sheet
  • Legacy Option: Adding your Data Source
  • Setting up your own Google Cloud Project user

Was this helpful?

  1. Data Sources
  2. Supported data sources

Google Sheets

PreviousGoogle AnalyticsNextMongoDB

Last updated 1 year ago

Was this helpful?

LogicLoop can also read data from Google Sheets.

Integrate Directly with Google Sheets

Follow our to get your LogicLoop workspace connected with Google Sheets.

Reading your Google Sheet

Then, select Google Sheets from the data source dropdown in your new query, and simply add the Spreadsheet ID in the query text, which you will find in the URL . This will get you all the data in the spreadsheet. You can refer to different sheets with SPREADSHEET_ID and PAGE.

Legacy Option: Adding your Data Source

First, you'll want to create a new Google Sheets Data Source.

Please email support@logicloop.com so we can help you upload the JSON Key File needed to activate the Google Sheets source.

Share your Google Sheet with logicloop@logicloop-322519.iam.gserviceaccount.com

Setting up your own Google Cloud Project user

How to create a Google Service Account?

  1. Click the “Create credentials” button. On the dropdown that appears, chose “Service account key”.

  2. On the following page, use the dropdown to select the project you elected in step 1. For role select Project > Viewer from the tree menu.

  3. Under key type, select JSON and hit “Create”

A .json file will then download to your computer. In LogicLoop under Data Sources, add a new data source for GoogleSpreadsheet. In the modal that appears, name this connection and upload the .json file you downloaded from the Google credentials console.

Now, you can follow the instructions above to share your Google Sheet with your own service account id (instead of logicloop@logicloop-322519.iam.gserviceaccount.com) and create a rule to read your data in.

If you'd like to do additional filtering or even write SQL against this data, use the

If instead of using our JSON file to connect to Google Sheets you would like to set it up yourself with your own Google Cloud Project, you first need to create a with Google. Service Accounts allow third-party applications like LogicLoop to read data from your Google apps without needing to log-in each time. During Service Account setup you will be provided with a JSON key file. You need to upload this file to LogicLoop when setting up the data source.

Open the . If prompted, select or create a project.

LogicLoop uses to parse dates from Google Spreadsheets. If you experience issues where LogicLoop parses the date incorrectly, try adjusting the date formatting in your sheet to ISO8601 or one of the formats shown .

Query Results datasource.
Service Account
API Credentials Page
Python-datutil
here
integration guide
https://docs.google.com/spreadsheets/d/{{ SPREADSHEET_ID }}/