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
  • 1. Lookup Spreadsheet Row
  • Component settings
  • 2. Batch Get
  • Component settings
  • 3. Batch Update
  • Component settings

Was this helpful?

  1. Flows
  2. Component Reference
  3. Apps
  4. Google Sheet

Data-level Operations

Operations related to rows, cells, or data content

Last updated 4 days ago

Was this helpful?

1. Lookup Spreadsheet Row

Component settings

Parameter Name
Description

Credentials

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

Action

Select the action: - Lookup Spreadsheet Row

Spreadsheet ID

Input the "Spreadsheet ID" you want to get the info

Query

Input the Query Example:

  • "An" → Find rows that contain the word "An".

  • "=23" → Find rows with a cell that contains the number 23.

  • "=B2='Nam'" → Find rows where cell B2 contains the value "Nam".

2. Batch Get

Component settings

Parameter Name
Description

Credentials

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

Action

Select the action: - Batch Get

Spreadsheet ID

Input the "Spreadsheet ID" you want to get the info

Ranges

Input the ranges you want to get info Ex:

3. Batch Update

Component settings

Parameter Name
Description

Credentials

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

Action

Select the action: - Batch Update

Spreadsheet ID

Input the "Spreadsheet ID" you want to update

Sheet Name

Input the "Sheet Name" you want to update

Values

Input the value you want to update Example:

🌊
[
  "Sheet1!A1:C5",
  "Sheet2!A1:B10
[
  [
    "name",
    "age",
    "class"
  ],
  [
    "An",
    18,
    "12A1"
  ],
  [
    "Binh",
    17,
    "11B2"
  ]
]