Lowcoder Documentation
  • Lowcoder overview
    • The "Hello World" walk
  • 🆕Setup and run
    • Cloud & Private Cloud
    • Self-hosting
      • Google Cloud Platform
      • Easypanel
      • Heroku
      • Raspberry Pi
      • Access local database or API
      • Update MongoDB Versions
      • Lowcoder Version Update
      • Traefik loadbalancer
      • SMTP Server
      • Migration from Openblocks
    • Security
  • 🏨Workspaces & Teamwork
    • Workspaces
      • SAAS Mode
      • Enterprise Mode
    • Members and Groups
    • Permissions for Resources
    • OAuth
      • KeyCloak
      • Google
      • GitHub
      • Generic OAuth Provider
    • Query library
    • Lowcoder Marketplace
  • ✨Build Applications
    • Create a new App
      • App(s) Navigation
      • Modules
      • Version and Release Management
    • App Editor
      • Query & Editing Roundtrips
      • Bulk Editing
      • Keyboard shortcuts
      • Data selection & Javascript
      • Layers
      • Visual Components
        • Common Component Settings
        • Messages / Toast
        • Dashboard & Reporting
          • Table
          • Charts and graphs
            • Bar Chart
            • Line Chart
            • Pie Chart
            • Scatter Chart
            • CandleStick Chart
            • Funnel Chart
            • Gauge Chart
            • Graph Chart
            • Heatmap Chart
            • Radar Chart
            • Sankey Chart
            • Suburst Chart
            • Theme River Chart
            • Tree Chart
            • Treemap Chart
            • Mermaid Chart
          • Google Maps
        • Layout & Navigation
          • List View
          • Drawer
          • Modal
          • Navigation
          • Cascader
          • Tree / Tree Select
          • Link
          • Floating Button
          • Text
          • Step Control
          • Page Layout
          • Content Card
          • Tabbed Container
        • Data Collection & Forms
          • Form
          • Input Field Types
          • JSON Schema Form
        • Meeting & Collaboration
        • Project Management
        • Calendar & Scheduling
          • Calendar
          • Date & Date Range
          • Time & Time Range
        • Document & File Management
          • File upload
        • Item & Signature Handling
        • Multimedia & Animation
          • Image
        • Integration & Extension
        • Legacy & Deprecated
      • Option lists
      • Date handling
      • Use Markdown
    • App Interaction
      • Event handlers
    • Themes & Styling
      • Design an efficient and user-friendly form
      • Customize Styles
      • Component Styling Possibilities
    • Video Calls in Lowcoder
  • 🚀Connect your Data
    • Data source basics
      • Configure IP allowlists
    • Data sources in Lowcoder
      • APIs as Datasource
        • REST API
        • GraphQL
        • Google Sheets
      • SQL Databases
        • MySQL
        • MariaDB
        • Supabase
          • Supabase PostgreSQL
          • Supabase Assets API
          • Supabase RealTime
          • Supabase OAuth
        • PostgreSQL
        • Microsoft SQL Server
        • Oracle
      • NoSQL Databases
        • MongoDB
        • CouchDB
        • DynamoDB
      • InMemory Databases
        • Redis
      • File Storages
        • S3 File Storage
      • BigData & OLAP
        • Big Query
        • Snowflake
        • ClickHouse
        • Elasticsearch
      • Websocket Datasource
    • Query basics
      • Bind Query Data to Components
      • Query library
  • 🪄Workflows
    • n8n Integration
  • 💫Business Logic in Apps
    • Write JavaScript
      • JavaScript query
      • Temporary state
      • Transformers
      • Data responder
      • Built-in JS functions
  • 🙌Publish Apps
    • Share an App
    • Publish an App
    • Embed an App
      • Embed App in HTML Pages
      • Embed App in WordPress Pages
      • Embed Apps in React
      • Embed Apps in NEXT.JS
      • Native embed SDK
        • Build the SDK from Source
  • 🔥Lowcoder Extension
    • Opensource Contribution
      • Develop UI components for Apps
      • Develop Data Source Plugins
    • Use third-party libraries in Apps
      • Day.js Date handling
      • Import your own JavaScript Library
    • Custom component
    • Lowcoder Open REST API
  • Lowcoder for Enterprise
    • Custom branding
Powered by GitBook
LogoLogo

More to try...

  • Lowcoder Website
  • Free Cloud Platform
  • Github
  • Discord

© Lowcoder Software LTD

On this page
  • Authentication
  • Create a service account key
  • Share your Google sheet
  • Connect Google Sheets to Lowcoder
  • Demo

Was this helpful?

  1. Connect your Data
  2. Data sources in Lowcoder
  3. APIs as Datasource

Google Sheets

PreviousGraphQLNextSQL Databases

Last updated 8 months ago

Was this helpful?

Authentication

Follow the steps below to create a service account for your Google Cloud project and share your Google sheet through the **** service account key.

Create a service account key

Follow the steps below:

  1. Enable the of your Google Cloud project.

  2. Select APIs & Services > Credentials from the left panel.

  3. Click + CREAT CREDENTIALS > Service account to create a new service account.

  4. Get a service account key:

    1. Click the Email of the service account.

    2. Click KEYS > ADD KEY > Create new key.

    3. Select JSON as the key type.

    4. Click CREATE to download it.

Now the service account key, in a JSON format, is downloaded to your device. Make sure to keep it somewhere safe.

Share your Google sheet

Navigate back to to , and follow the steps below to share your sheet through the **** service account key.

  1. Open the JSON file of the key.

  2. Copy the value of client_email, which is an identity used for access management of your sheet.

  3. Click Share at the top right and paste the copied client_email value to add a member with access.

  4. Select Editor as the role and click Send.

When you see the notification Access updated, you have authorized this service account to edit your sheet.

Connect Google Sheets to Lowcoder

Follow the steps below:

  1. Click Data Sources on Lowcoder homepage.

  2. Click New Data Source on the top right. Note that this permission is restricted to workspace admins and developers.

  3. Select Database > Google Sheets as the type.

  4. Set its name and paste the whole content in the JSON flie of the key to Service Account.

  5. Click Save, and you can check it in your data source library later.

  6. To access and manipulate data in your app, you can fill in the Spreadsheet id and Sheet Name in a query editor as follows.

    The available methods are Read Data, Append Row, Update Row, and Clear Row.

Demo

🚀
Google Sheets API
Google Sheets