Google Drive Node

The Google Drive node provides integration with Google Drive and Google Sheets in SkyStudio workflows. You can read and search files, manage folders, and perform spreadsheet operations.

🎬 Click to watch the video →

Connection Setup and Management

To use the Google Drive node, you must first create a Google account connection. Unlike Jira and Confluence, Google Drive uses the OAuth 2.0 authentication method.

Adding a New Connection

Go to Application Connections from the left menu in SkyStudio.
Click Google Drive.
Make sure OAuth 2.0 is selected as the Connection Method, which is the default and recommended option.
Enter a name for this connection in the Connection Name field. This field is required.
Click the Authorize with Google button.

Field	Description	Example
Connection Name	The name you want to give this connection	`Company Google Drive`
Connection Method	Authentication type	`OAuth 2.0` recommended

Connection Methods

OAuth 2.0 Recommended
Authorization is performed through your Google account in the browser. When the backend OAuth URL is configured, it opens with a single click. This is the safest and easiest method.

API Key / Advanced
You can manually enter credentials in JSON format. Use this method if you want to use your own Google Cloud OAuth client.

Authorization Steps

Click the Authorize with Google button.
Select your account in the Google sign-in window that opens.
Approve the permissions requested by SkyStudio.
Once authorization is successful, the connection is saved automatically.

Note: During authorization, Google will request permissions for Drive and Sheets access. Approve all requested permissions so your workflows can run properly.

Assigning the Connection to the Node

After dragging the Google Drive node onto the canvas, select the connection you created from the Application Connections dropdown in the right panel.

Operations

The Google Drive node provides 13 operations:

Operation	Category	Description
List Files	Featured	Lists files and folders in a specific folder
Search File	Featured	Searches files in Drive using a search query
Google Drive AI Assistant	Featured	Queries Drive files using natural language
Get Spreadsheet Rows	Featured	Retrieves row data from Google Sheets
Read File Content	Featured	Reads the content of a file, with an AI analysis option
Ask File	Featured	Asks a natural language question about a file
Get File Information	Standard	Retrieves file metadata
Create Folder	Standard	Creates a new folder in Drive
Spreadsheet Information	Standard	Retrieves metadata about Google Sheets
Add Row	Standard	Adds a new row to Google Sheets
Update Cell	Standard	Updates cell values in Google Sheets
Clear Cells	Standard	Clears cells in Google Sheets
Create Spreadsheet	Standard	Creates a new Google Sheets file

List Files

Lists all files and subfolders in a specific folder. If no Folder ID is provided, the root directory of Drive is listed.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Folder ID	No	Drive ID of the folder to list. If left empty, the root directory is used
Page Size	No	Number of files to retrieve per page

How to Find the Folder ID

Open the folder in Google Drive. The last segment in the URL is the Folder ID.

Example:

https://drive.google.com/drive/folders/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs

ID:

1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs

Search File

Searches files using Google Drive search syntax. You can filter by name, content, MIME type, and other criteria.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Search Query	Yes	Drive search query
Page Size	No	Number of results to retrieve per page

Search Query Examples

Purpose	Query
Search by name	`name contains 'report'`
Find a specific type	`mimeType = 'application/pdf'`
Search inside a folder	`'FOLDER_ID' in parents`
Starred files	`starred = true`
Recently modified	`modifiedTime > '2024-01-01'`

Google Drive AI Assistant

Queries your Drive files using natural language. It is used to interpret file contents and extract information.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Query	Yes	Natural language question or task
System Prompt	No	Instruction that customizes AI behavior

Usage Example

Query: "Find and summarize the meeting notes shared last month"

System Prompt: "Look only at files in the 'Meeting Notes' folder. Respond in Turkish."

Get Spreadsheet Rows

Retrieves rows from a specific range in Google Sheets in JSON format.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Spreadsheet ID	Yes	Drive ID of the Google Sheets file
Range	No	Cell range to read, such as `Sheet1!A1:D100`
First Row is Header	No	Whether the first row is used as the header row

How to Find the Spreadsheet ID

The part between /d/ and /edit in the Google Sheets URL is the Spreadsheet ID.

Example:

https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs/edit

ID:

1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs

Range Format

Entire sheet: Sheet1 or Sayfa1
Specific range: Sheet1!A1:D50
Entire column A: Sheet1!A:A
First 10 rows: Sheet1!1:10

Read File Content

Reads the content of a file in Google Drive. Depending on the read method, it can return raw text, AI analysis, or structured data.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
File ID	Yes	Drive ID of the file to read
Read Method	No	Reading method, such as `raw` or `analyze`
After Reading	No	Action to perform after reading
AI Prompt if analyzing	No	Instruction to use for AI analysis
Response Language	No	Response language

Supported File Types

Google Docs, Google Sheets, Google Slides, PDF, TXT, DOCX, and other text-based files can be read.

Ask File

Allows you to ask a natural language question about a Drive file. The file content is automatically loaded and processed with AI.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
File ID	Yes	Drive ID of the file to query
Question	Yes	Natural language question to ask about the file
Response Language	No	Response language

Usage Example

File ID: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs

Question: "What are the main findings in this report? List them as bullet points."

Response Language: Turkish

Get File Information

Retrieves metadata such as file name, size, creation date, and MIME type. It does not read the file content.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
File ID	Yes	Drive ID of the file whose metadata will be retrieved

Example Output

{
  "id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs",
  "name": "Q4 Sales Report.pdf",
  "mimeType": "application/pdf",
  "size": "245760",
  "createdTime": "2024-10-01T09:00:00.000Z",
  "modifiedTime": "2024-11-15T14:30:00.000Z",
  "webViewLink": "https://drive.google.com/file/d/..."
}

Create Folder

Creates a new folder in Google Drive. Optionally, it can be created inside an existing folder.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Folder Name	Yes	Name of the folder to create
Parent Folder ID	No	Drive ID of the parent folder. If left empty, the root directory is used

Spreadsheet Information

Retrieves structural metadata about a Google Sheets file, such as sheet names and row/column counts.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Spreadsheet ID	Yes	ID of the Sheets file whose information will be retrieved

Add Row

Adds one or more new rows to an existing Google Sheets sheet.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Spreadsheet ID	Yes	ID of the target Sheets file
Sheet Name	Yes	Name of the sheet where rows will be added, such as `Sheet1`
Rows (JSON)	Yes	Row data to add, in JSON array format

Rows Format

[
  {
    "Name": "Ayşe",
    "Surname": "Kaya",
    "Department": "Marketing"
  },
  {
    "Name": "Mehmet",
    "Surname": "Demir",
    "Department": "Engineering"
  }
]

Update Cell

Updates cell values in a specific range in Google Sheets.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Spreadsheet ID	Yes	ID of the target Sheets file
Range	Yes	Cell range to update, such as `Sheet1!B2:C3`
Values (2D JSON Array)	Yes	Values to write, in 2D array format

Values Format

[
  ["New Value 1", "New Value 2"],
  ["New Value 3", "New Value 4"]
]

Clear Cells

Clears cell contents in a specific range in Google Sheets. Formatting is preserved.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Spreadsheet ID	Yes	ID of the target Sheets file
Range	Yes	Cell range to clear, such as `Sheet1!A2:Z1000`

Note: This operation only clears cell contents and preserves cell formatting, such as colors and fonts.

Create Spreadsheet

Creates a new Google Sheets file. You can define the initial sheet names.

Parameters

Parameter	Required	Description
Connection	Yes	The Google Drive connection to use
Spreadsheet Title	Yes	Name of the Sheets file to create
Sheet Names CSV	No	Comma-separated sheet names, such as `January,February,March`

Example Output

{
  "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs",
  "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/...",
  "title": "2025 Sales Tracking Sheet"
}

Quick Start Examples

Example 1: Document Q&A Assistant

A workflow where the user can ask questions about any document in Drive:

Text Input (File ID) → Ask File → Text Output

Ask File settings:

File ID: {{input.file_id}}
Question: {{input.question}}
Response Language: Turkish

Example 2: Automatic Report Collection

A workflow that finds all PDF reports in a specific folder and summarizes their contents:

Search File → Loop → Read File Content → LLM (summarize) → Add Row

Search File settings:

Search Query: 'FOLDER_ID' in parents and mimeType = 'application/pdf'

Read File Content settings:

Read Method: analyze
AI Prompt: "Summarize the main findings of this report in 3 bullet points"

Example 3: Save Form Data to Sheets

A workflow that automatically writes form data received through a webhook to Google Sheets:

Webhook → Add Row (Google Sheets)

Add Row settings:

Spreadsheet ID: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs
Sheet Name: Applications
Rows (JSON): [{"Name": "{{webhook.name}}", "Email": "{{webhook.email}}", "Date": "{{now}}"}]

Example 4: Creating Folder Structure

A workflow that automatically creates a standard folder structure for a new project:

Text Input (Project Name) → Create Folder (Main) → Create Folder (Sub1) → Create Folder (Sub2)

First Create Folder settings:

Folder Name: {{input.project_name}}
Parent Folder ID: PROJECTS_FOLDER_ID

Common Errors

Error	Possible Cause	Solution
`401 Unauthorized`	OAuth token has expired	Reauthorize with Google to refresh the connection
`403 Forbidden`	No permission to access the file	Check sharing settings in Google Drive
`404 File not found`	Invalid File ID or Spreadsheet ID	Copy the ID again from the Drive URL
`Invalid range`	Incorrect Range format	Make sure you use the `Sheet1!A1:D10` format
`Quota exceeded`	Daily Google API limit exceeded	Add delay between requests or try again the next day
`Token has been expired`	OAuth authorization has expired	Refresh the connection from Application Connections

Notes

File ID and Spreadsheet ID refer to the same concept. Every Google Sheets file is also a Drive file.
Google Drive API has daily request limits. For large data operations, consider Page Size and request intervals.
Ask File and Read File Content (AI analysis) operations may take longer for large files.
Binary files outside Google Workspace, such as images and videos, may not be supported for content reading.

Connection Setup and Management​

Adding a New Connection​

Connection Methods​

Authorization Steps​

Assigning the Connection to the Node​

Operations

List Files

Parameters​

How to Find the Folder ID​

Search File

Parameters​

Search Query Examples​

Google Drive AI Assistant

Parameters​

Usage Example​

Get Spreadsheet Rows

Parameters​

How to Find the Spreadsheet ID​

Range Format​

Read File Content

Parameters​

Supported File Types​

Ask File

Parameters​

Usage Example​

Get File Information

Parameters​

Example Output​

Create Folder

Parameters​

Spreadsheet Information

Parameters​

Add Row

Parameters​

Rows Format​

Update Cell

Parameters​

Values Format​

Clear Cells

Parameters​

Create Spreadsheet

Parameters​

Example Output​

Quick Start Examples

Example 1: Document Q&A Assistant​

Example 2: Automatic Report Collection​

Example 3: Save Form Data to Sheets​

Example 4: Creating Folder Structure​

Common Errors

Notes

Connection Setup and Management

Adding a New Connection

Connection Methods

Authorization Steps

Assigning the Connection to the Node

Parameters

How to Find the Folder ID

Parameters

Search Query Examples

Parameters

Usage Example

Parameters

How to Find the Spreadsheet ID

Range Format

Parameters

Supported File Types

Parameters

Usage Example

Parameters

Example Output

Parameters

Parameters

Parameters

Rows Format

Parameters

Values Format

Parameters

Parameters

Example Output

Example 1: Document Q&A Assistant

Example 2: Automatic Report Collection

Example 3: Save Form Data to Sheets

Example 4: Creating Folder Structure