Diaflow's Documentation
HomePricingIntegrations
Documentation
Documentation
  • 😎WELCOME TO DIAFLOW
    • Introduction to Generative AI
    • What can you build with Diaflow?
  • 💻USER ACCOUNT
    • Create your user account
    • Delete your user account
    • Log out and log in
    • Change "Personal" & "Workspace" settings
    • Reset user account password
  • 🚀Getting Started
    • Let's start with the basics
      • How a component works?
      • How a flow works?
      • Creating your first flow
    • Dashboard
      • Services
      • Create a flow from scratch
      • Create a flow from templates
      • View your flows
    • Terminology
  • 🌊Flows
    • Overview
    • Create a flow
    • Delete a flow
    • Manage a flow
    • Publish a flow
    • Unpublish a flow
    • Deployment
    • Component Reference
      • Trigger
        • When inputs are submitted (Apps)
        • Cronjob (Automation)
        • Webhook (Automation)
        • Microsoft Outlook (Automation)
      • Outputs (Apps)
        • Text Output
        • Chart Output
        • Video Output
        • Audio Output
        • Image Output
      • Built in tools
        • Branch
        • Merge (Multiple data source to JSON)
        • Split Data (JSON Formatter)
        • Video to audio
        • Get current date and time
        • Web scraper
        • Document to plain text
        • Retrieve data from spreadsheet (Spreadsheet analyzer)
        • Spreadsheet creator
        • Convert JSON to chart data
        • PDF to image
        • Get weather information
        • HTTP Request
        • Get GEO Location
        • SMTP
        • Loop
      • Built in resources
        • Diaflow Vision
        • Diaflow Vectors
        • Diaflow Drive
        • Diaflow Table
      • Apps
        • Hunter.io
        • Outlook Email
        • Telegram
        • Slack
        • Python
        • YouTube
        • SerpAPI
        • Google Sheet
          • Document-level Operations
          • Sheet-level Operations
          • Data-level Operations
      • Database
        • MySQL
        • Microsoft SQL
        • PostgreSQL
        • Snowflake
      • Private AI/LLM Models
        • OpenAI
          • GPT Variants
          • GPT Vision
          • DALL-E Variants
          • TTS Variants
          • Whisper
        • Anthropic
        • Llama
        • Google Gemini
        • Cohere
        • MistralAI
      • Public AI/LLM Models
        • OpenAI Cloud
        • Perplexity Cloud
        • Deepseek Cloud
        • Anthropic Cloud
        • Replicate
        • Straico
        • OpenRouter
        • Cohere Cloud
        • Google Gemini Cloud
        • MistralAI Cloud
        • ElevenLabs Cloud
      • AI Tools
  • ✒️PRODUCTIVITY TOOLS
    • Tables
    • Drive
    • Vectors
      • Document
      • Article
      • URLs
  • 🏠Workspace
    • History
    • Teams
    • Billing & Subscription
      • Upgrade/Downgrade a subscription
      • Buy credits
      • Credit Usage
      • Cancel a subscription
    • Settings
      • Personnal
      • Workspace
        • Change workspace
        • Workspace settings
        • Custom Domain
        • Delete workspace
      • Change Language
    • Documentation
    • Integrations
    • API keys
  • 📑Other
    • FAQs
    • Contact Information
Powered by GitBook
On this page
  • Description
  • Component settings
  • Operations
  • Document-level Operations
  • Sheet-level Operations
  • Data-level Operations

Was this helpful?

  1. Flows
  2. Component Reference
  3. Apps

Google Sheet

The Google Sheet node allows you to seamlessly read from and write data to Google Sheets. It supports various actions such as appending rows, updating cells, retrieving data, and more.

Last updated 4 days ago

Was this helpful?

Description

What it does: This node allows you to connect and interact with Google Sheets, enabling you to read, write, update, and manage spreadsheet data dynamically within a workflow.

When to use it? : Use this node when you need to integrate Google Sheets as a data source or destination, such as logging workflow outputs, retrieving configuration data, or automating spreadsheet operations.

Component settings

Parameter Name
Description

Credentials

Connect your Google account to authorize access to Google Sheets. Required to perform any actions.

Action

Select the operation you want to perform on the spreadsheet. Available actions include: - Create a new Google sheet - Create Sheet from JSON - Lookup Spreadsheet Row - Get Sheet Names - Get Spreadsheet Info - Batch Get - Batch update - Clear Values

Another fields

Based on the action, another field will display on the node: - Spreadsheet ID - Ranges - Title - Sheet Name - Sheet JSON - Query - Value - ...

Operations

Operations related to the entire Google Sheet file:

  • Create a new Google Sheet: Create a new Google Sheet document.

  • Get Spreadsheet Info: Retrieve general information about the spreadsheet, including the list of sheets and metadata.

Operations related to individual sheets within a spreadsheet:

  • Create Sheet from JSON: Create a new sheet and populate it with data from a JSON string.

  • Get Sheet Names: Retrieve the names of all sheets in the spreadsheet.

  • Clear Values: Clear data within a sheet, either entirely or from a specified range.

Operations related to rows, cells, or data content:

  • Lookup Spreadsheet Row: Search for a row based on a specific column value.

  • Batch Get: Retrieve data from multiple ranges or sheets at once.

  • Batch Update: Update multiple cells or data ranges in bulk.

🌊
Document-level Operations
Sheet-level Operations
Data-level Operations