Arcade.dev LLM tools for Google Workspace
Arcade.dev provides tools for integrating with Google Workspace, enabling developers to automate tasks and enhance productivity through access to various Google services.
Capabilities
- Manage calendar events, including creation, deletion, and updates.
- Access and manipulate Gmail functionalities, such as sending emails and organizing threads and labels.
- Interact with Google Drive for file management, including document creation and retrieval.
- Create and manage contacts within Google Contacts seamlessly.
OAuth
Uses Google OAuth 2.0 for authentication, requiring the following scopes:
https://www.googleapis.com/auth/calendar.eventshttps://www.googleapis.com/auth/contactshttps://www.googleapis.com/auth/gmail.*
Secrets
No secrets are utilized in this toolkit.
Available tools(37)
| Tool name | Description | Secrets | |
|---|---|---|---|
Add and remove labels from an email using the Gmail API. | |||
Create a blank Google Docs document with the specified title. | |||
Create a new contact record in Google Contacts.
Examples:
```
create_contact(given_name="Alice")
create_contact(given_name="Alice", family_name="Smith")
create_contact(given_name="Alice", email="alice@example.com")
``` | |||
Create a Google Docs document with the specified title and text content. | |||
Create a new event/meeting/sync/meetup in the specified calendar. | |||
Create a new label in the user's mailbox. | |||
Create a new spreadsheet with the provided title and data in its first sheet
Returns the newly created spreadsheet's id and title | |||
Delete a draft email using the Gmail API. | |||
Delete an event from Google Calendar. | |||
Provides time slots when everyone is free within a given date range and time boundaries. | |||
Generate a Google File Picker URL for user-driven file selection and authorization.
This tool generates a URL that directs the end-user to a Google File Picker interface where
where they can select or upload Google Drive files. Users can grant permission to access their
Drive files, providing a secure and authorized way to interact with their files.
This is particularly useful when prior tools (e.g., those accessing or modifying
Google Docs, Google Sheets, etc.) encountered failures due to file non-existence
(Requested entity was not found) or permission errors. Once the user completes the file
picker flow, the prior tool can be retried. | |||
Get the latest version of the specified Google Docs document. | |||
Get the file/folder tree structure of the user's Google Drive. | |||
Get the user entered values and formatted values for all cells in all sheets in the spreadsheet
along with the spreadsheet's properties | |||
Get the specified thread by ID. | |||
Updates an existing Google Docs document using the batchUpdate API endpoint. | |||
List all calendars accessible by the user. | |||
Lists draft emails in the user's draft mailbox using the Gmail API. | |||
Read emails from a Gmail account and extract plain text content. | |||
Search for emails by header using the Gmail API.
At least one of the following parameters MUST be provided: sender, recipient,
subject, date_range, label, or body. | |||
List events from the specified calendar within the given datetime range.
min_end_datetime serves as the lower bound (exclusive) for an event's end time.
max_start_datetime serves as the upper bound (exclusive) for an event's start time.
For example:
If min_end_datetime is set to 2024-09-15T09:00:00 and max_start_datetime
is set to 2024-09-16T17:00:00, the function will return events that:
1. End after 09:00 on September 15, 2024 (exclusive)
2. Start before 17:00 on September 16, 2024 (exclusive)
This means an event starting at 08:00 on September 15 and
ending at 10:00 on September 15 would be included, but an
event starting at 17:00 on September 16 would not be included. | |||
List all the labels in the user's mailbox. | |||
List threads in the user's mailbox. | |||
Send a reply to an email message. | |||
Searches for documents in the user's Google Drive and returns a list of documents (with text
content) matching the search criteria. Excludes documents that are in the trash.
Note: use this tool only when the user prompt requires the documents' content. If the user only
needs a list of documents, use the `search_documents` tool instead. |
Selected tools
No tools selected.
Click "Show all tools" to add tools.
Requirements
Select tools to see requirements
Google.ChangeEmailLabels
Add and remove labels from an email using the Gmail API.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
email_id | string | Required | The ID of the email to modify labels for |
labels_to_add | array<string> | Required | List of label names to add |
labels_to_remove | array<string> | Required | List of label names to remove |
Requirements
Output
json— List of labels that were added, removed, and not foundGoogle.CreateBlankDocument
Create a blank Google Docs document with the specified title.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
title | string | Required | The title of the blank document to create |
Requirements
Output
json— The created document's title, documentId, and documentUrl in a dictionaryGoogle.CreateContact
Create a new contact record in Google Contacts. Examples: ``` create_contact(given_name="Alice") create_contact(given_name="Alice", family_name="Smith") create_contact(given_name="Alice", email="alice@example.com") ```
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
given_name | string | Required | The given name of the contact |
family_name | string | Optional | The optional family name of the contact |
email | string | Optional | The optional email address of the contact |
Requirements
Output
json— A dictionary containing the details of the created contactGoogle.CreateDocumentFromText
Create a Google Docs document with the specified title and text content.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
title | string | Required | The title of the document to create |
text_content | string | Required | The text content to insert into the document |
Requirements
Output
json— The created document's title, documentId, and documentUrl in a dictionaryGoogle.CreateEvent
Create a new event/meeting/sync/meetup in the specified calendar.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
summary | string | Required | The title of the event |
start_datetime | string | Required | The datetime when the event starts in ISO 8601 format, e.g., '2024-12-31T15:30:00'. |
end_datetime | string | Required | The datetime when the event ends in ISO 8601 format, e.g., '2024-12-31T17:30:00'. |
calendar_id | string | Optional | The ID of the calendar to create the event in, usually 'primary'. |
description | string | Optional | The description of the event |
location | string | Optional | The location of the event |
visibility | string | Optional | The visibility of the eventdefaultpublicprivateconfidential |
attendee_emails | array<string> | Optional | The list of attendee emails. Must be valid email addresses e.g., username@domain.com. |
Requirements
Output
json— A dictionary containing the created event detailsGoogle.CreateLabel
Create a new label in the user's mailbox.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
label_name | string | Required | The name of the label to create |
Requirements
Output
json— The details of the created labelGoogle.CreateSpreadsheet
Create a new spreadsheet with the provided title and data in its first sheet Returns the newly created spreadsheet's id and title
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
title | string | Optional | The title of the new spreadsheet |
data | string | Optional | The data to write to the spreadsheet. A JSON string (property names enclosed in double quotes) representing a dictionary that maps row numbers to dictionaries that map column letters to cell values. For example, data[23]['C'] would be the value of the cell in row 23, column C. Type hint: dict[int, dict[str, Union[int, float, str, bool]]] |
Requirements
Output
json— The created spreadsheet's id and titleGoogle.DeleteDraftEmail
Delete a draft email using the Gmail API.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
draft_email_id | string | Required | The ID of the draft email to delete |
Requirements
Output
string— A confirmation message indicating successful deletionGoogle.DeleteEvent
Delete an event from Google Calendar.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
event_id | string | Required | The ID of the event to delete |
calendar_id | string | Optional | The ID of the calendar containing the event |
send_updates | string | Optional | Specifies which attendees to notify about the deletionnoneallexternalOnly |
Requirements
Output
string— A string containing the deletion confirmation messageGoogle.FindTimeSlotsWhenEveryoneIsFree
Provides time slots when everyone is free within a given date range and time boundaries.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
email_addresses | array<string> | Optional | The list of email addresses from people in the same organization domain (apart from the currently logged in user) to search for free time slots. Defaults to None, which will return free time slots for the current user only. |
start_date | string | Optional | The start date to search for time slots in the format 'YYYY-MM-DD'. Defaults to today's date. It will search starting from this date at the time 00:00:00. |
end_date | string | Optional | The end date to search for time slots in the format 'YYYY-MM-DD'. Defaults to seven days from the start date. It will search until this date at the time 23:59:59. |
start_time_boundary | string | Optional | Will return free slots in any given day starting from this time in the format 'HH:MM'. Defaults to '08:00', which is a usual business hour start time. |
end_time_boundary | string | Optional | Will return free slots in any given day until this time in the format 'HH:MM'. Defaults to '18:00', which is a usual business hour end time. |
Requirements
Output
json— A dictionary with the free slots and the timezone in which time slots are represented.Google.GenerateGoogleFilePickerUrl
Generate a Google File Picker URL for user-driven file selection and authorization. This tool generates a URL that directs the end-user to a Google File Picker interface where where they can select or upload Google Drive files. Users can grant permission to access their Drive files, providing a secure and authorized way to interact with their files. This is particularly useful when prior tools (e.g., those accessing or modifying Google Docs, Google Sheets, etc.) encountered failures due to file non-existence (Requested entity was not found) or permission errors. Once the user completes the file picker flow, the prior tool can be retried.
Parameters
No parameters required.
Requirements
Output
json— Google File Picker URL for user file selection and permission grantingGoogle.GetDocumentById
Get the latest version of the specified Google Docs document.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
document_id | string | Required | The ID of the document to retrieve. |
Requirements
Output
json— The document contents as a dictionaryGoogle.GetFileTreeStructure
Get the file/folder tree structure of the user's Google Drive.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
include_shared_drives | boolean | Optional | Whether to include shared drives in the file tree structure. Defaults to False. |
restrict_to_shared_drive_id | string | Optional | If provided, only include files from this shared drive in the file tree structure. Defaults to None, which will include files and folders from all drives. |
include_organization_domain_documents | boolean | Optional | Whether to include documents from the organization's domain. This is applicable to admin users who have permissions to view organization-wide documents in a Google Workspace account. Defaults to False. |
order_by | array<string> | Optional | Sort order. Defaults to listing the most recently modified documents firstcreatedTimecreatedTime descfolderfolder descmodifiedByMeTimemodifiedByMeTime descmodifiedTimemodifiedTime descnamename descname_naturalname_natural descquotaBytesUsedquotaBytesUsed descrecencyrecency descsharedWithMeTimesharedWithMeTime descstarredstarred descviewedByMeTimeviewedByMeTime desc |
limit | integer | Optional | The number of files and folders to list. Defaults to None, which will list all files and folders. |
Requirements
Output
json— A dictionary containing the file/folder tree structure in the user's Google DriveGoogle.GetSpreadsheet
Get the user entered values and formatted values for all cells in all sheets in the spreadsheet along with the spreadsheet's properties
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
spreadsheet_id | string | Required | The id of the spreadsheet to get |
Requirements
Output
json— The spreadsheet properties and data for all sheets in the spreadsheetGoogle.GetThread
Get the specified thread by ID.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
thread_id | string | Required | The ID of the thread to retrieve |
Requirements
Output
json— A dictionary containing the thread detailsGoogle.InsertTextAtEndOfDocument
Updates an existing Google Docs document using the batchUpdate API endpoint.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
document_id | string | Required | The ID of the document to update. |
text_content | string | Required | The text content to insert into the document |
Requirements
Output
json— The response from the batchUpdate API as a dict.Google.ListCalendars
List all calendars accessible by the user.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
max_results | integer | Optional | The maximum number of calendars to return. Up to 250 calendars, defaults to 10. |
show_deleted | boolean | Optional | Whether to show deleted calendars. Defaults to False |
show_hidden | boolean | Optional | Whether to show hidden calendars. Defaults to False |
next_page_token | string | Optional | The token to retrieve the next page of calendars. Optional. |
Requirements
Output
json— A dictionary containing the calendars accessible by the end userGoogle.ListDraftEmails
Lists draft emails in the user's draft mailbox using the Gmail API.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
n_drafts | integer | Optional | Number of draft emails to read |
Requirements
Output
json— A dictionary containing a list of draft email detailsGoogle.ListEmails
Read emails from a Gmail account and extract plain text content.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
n_emails | integer | Optional | Number of emails to read |
Requirements
Output
json— A dictionary containing a list of email detailsGoogle.ListEmailsByHeader
Search for emails by header using the Gmail API. At least one of the following parameters MUST be provided: sender, recipient, subject, date_range, label, or body.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
sender | string | Optional | The name or email address of the sender of the email |
recipient | string | Optional | The name or email address of the recipient |
subject | string | Optional | Words to find in the subject of the email |
body | string | Optional | Words to find in the body of the email |
date_range | string | Optional | The date range of the emailtodayyesterdaylast_7_dayslast_30_daysthis_monthlast_monththis_year |
label | string | Optional | The label name to filter by |
max_results | integer | Optional | The maximum number of emails to return |
Requirements
Output
json— A dictionary containing a list of email details matching the search criteriaGoogle.ListEvents
List events from the specified calendar within the given datetime range. min_end_datetime serves as the lower bound (exclusive) for an event's end time. max_start_datetime serves as the upper bound (exclusive) for an event's start time. For example: If min_end_datetime is set to 2024-09-15T09:00:00 and max_start_datetime is set to 2024-09-16T17:00:00, the function will return events that: 1. End after 09:00 on September 15, 2024 (exclusive) 2. Start before 17:00 on September 16, 2024 (exclusive) This means an event starting at 08:00 on September 15 and ending at 10:00 on September 15 would be included, but an event starting at 17:00 on September 16 would not be included.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
min_end_datetime | string | Required | Filter by events that end on or after this datetime in ISO 8601 format, e.g., '2024-09-15T09:00:00'. |
max_start_datetime | string | Required | Filter by events that start before this datetime in ISO 8601 format, e.g., '2024-09-16T17:00:00'. |
calendar_id | string | Optional | The ID of the calendar to list events from |
max_results | integer | Optional | The maximum number of events to return |
Requirements
Output
json— A dictionary containing the list of eventsGoogle.ListLabels
List all the labels in the user's mailbox.
Parameters
No parameters required.
Requirements
Output
json— A dictionary containing a list of label detailsGoogle.ListThreads
List threads in the user's mailbox.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
page_token | string | Optional | Page token to retrieve a specific page of results in the list |
max_results | integer | Optional | The maximum number of threads to return |
include_spam_trash | boolean | Optional | Whether to include spam and trash in the results |
Requirements
Output
json— A dictionary containing a list of thread detailsGoogle.ReplyToEmail
Send a reply to an email message.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
body | string | Required | The body of the email |
reply_to_message_id | string | Required | The ID of the message to reply to |
reply_to_whom | string | Optional | Whether to reply to every recipient (including cc) or only to the original sender. Defaults to 'GmailReplyToWhom.ONLY_THE_SENDER'.every_recipientonly_the_sender |
bcc | array<string> | Optional | BCC recipients of the email |
Requirements
Output
json— A dictionary containing the sent email detailsGoogle.SearchAndRetrieveDocuments
Searches for documents in the user's Google Drive and returns a list of documents (with text content) matching the search criteria. Excludes documents that are in the trash. Note: use this tool only when the user prompt requires the documents' content. If the user only needs a list of documents, use the `search_documents` tool instead.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
return_format | string | Optional | The format of the document to return. Defaults to Markdown.markdownhtmlgoogle_api_json |
document_contains | array<string> | Optional | Keywords or phrases that must be in the document title or body. Provide a list of keywords or phrases if needed. |
document_not_contains | array<string> | Optional | Keywords or phrases that must NOT be in the document title or body. Provide a list of keywords or phrases if needed. |
search_only_in_shared_drive_id | string | Optional | The ID of the shared drive to restrict the search to. If provided, the search will only return documents from this drive. Defaults to None, which searches across all drives. |
include_shared_drives | boolean | Optional | Whether to include documents from shared drives. Defaults to False (searches only in the user's 'My Drive'). |
include_organization_domain_documents | boolean | Optional | Whether to include documents from the organization's domain. This is applicable to admin users who have permissions to view organization-wide documents in a Google Workspace account. Defaults to False. |
order_by | array<string> | Optional | Sort order. Defaults to listing the most recently modified documents firstcreatedTimecreatedTime descfolderfolder descmodifiedByMeTimemodifiedByMeTime descmodifiedTimemodifiedTime descnamename descname_naturalname_natural descquotaBytesUsedquotaBytesUsed descrecencyrecency descsharedWithMeTimesharedWithMeTime descstarredstarred descviewedByMeTimeviewedByMeTime desc |
limit | integer | Optional | The number of documents to list |
pagination_token | string | Optional | The pagination token to continue a previous request |
Requirements
Output
json— A dictionary containing 'documents_count' (number of documents returned) and 'documents' (a list of documents with their content).Google.SearchContactsByEmail
Search the user's contacts in Google Contacts by email address.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
email | string | Required | The email address to search for |
limit | integer | Optional | The maximum number of contacts to return (30 is the max allowed by Google API) |
Requirements
Output
json— A dictionary containing the list of matching contactsGoogle.SearchContactsByName
Search the user's contacts in Google Contacts by name.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
name | string | Required | The full name to search for |
limit | integer | Optional | The maximum number of contacts to return (30 is the max allowed by Google API) |
Requirements
Output
json— A dictionary containing the list of matching contactsGoogle.SearchDocuments
Searches for documents in the user's Google Drive. Excludes documents that are in the trash.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
document_contains | array<string> | Optional | Keywords or phrases that must be in the document title or body. Provide a list of keywords or phrases if needed. |
document_not_contains | array<string> | Optional | Keywords or phrases that must NOT be in the document title or body. Provide a list of keywords or phrases if needed. |
search_only_in_shared_drive_id | string | Optional | The ID of the shared drive to restrict the search to. If provided, the search will only return documents from this drive. Defaults to None, which searches across all drives. |
include_shared_drives | boolean | Optional | Whether to include documents from shared drives. Defaults to False (searches only in the user's 'My Drive'). |
include_organization_domain_documents | boolean | Optional | Whether to include documents from the organization's domain. This is applicable to admin users who have permissions to view organization-wide documents in a Google Workspace account. Defaults to False. |
order_by | array<string> | Optional | Sort order. Defaults to listing the most recently modified documents firstcreatedTimecreatedTime descfolderfolder descmodifiedByMeTimemodifiedByMeTime descmodifiedTimemodifiedTime descnamename descname_naturalname_natural descquotaBytesUsedquotaBytesUsed descrecencyrecency descsharedWithMeTimesharedWithMeTime descstarredstarred descviewedByMeTimeviewedByMeTime desc |
limit | integer | Optional | The number of documents to list |
pagination_token | string | Optional | The pagination token to continue a previous request |
Requirements
Output
json— A dictionary containing 'documents_count' (number of documents returned) and 'documents' (a list of document details including 'kind', 'mimeType', 'id', and 'name' for each document)Google.SearchThreads
Search for threads in the user's mailbox
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
page_token | string | Optional | Page token to retrieve a specific page of results in the list |
max_results | integer | Optional | The maximum number of threads to return |
include_spam_trash | boolean | Optional | Whether to include spam and trash in the results |
label_ids | array<string> | Optional | The IDs of labels to filter by |
sender | string | Optional | The name or email address of the sender of the email |
recipient | string | Optional | The name or email address of the recipient |
subject | string | Optional | Words to find in the subject of the email |
body | string | Optional | Words to find in the body of the email |
date_range | string | Optional | The date range of the emailtodayyesterdaylast_7_dayslast_30_daysthis_monthlast_monththis_year |
Requirements
Output
json— A dictionary containing a list of thread detailsGoogle.SendDraftEmail
Send a draft email using the Gmail API.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
email_id | string | Required | The ID of the draft to send |
Requirements
Output
json— A dictionary containing the sent email detailsGoogle.SendEmail
Send an email using the Gmail API.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
subject | string | Required | The subject of the email |
body | string | Required | The body of the email |
recipient | string | Required | The recipient of the email |
cc | array<string> | Optional | CC recipients of the email |
bcc | array<string> | Optional | BCC recipients of the email |
Requirements
Output
json— A dictionary containing the sent email detailsGoogle.TrashEmail
Move an email to the trash folder using the Gmail API.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
email_id | string | Required | The ID of the email to trash |
Requirements
Output
json— A dictionary containing the trashed email detailsGoogle.UpdateDraftEmail
Update an existing email draft using the Gmail API.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
draft_email_id | string | Required | The ID of the draft email to update. |
subject | string | Required | The subject of the draft email |
body | string | Required | The body of the draft email |
recipient | string | Required | The recipient of the draft email |
cc | array<string> | Optional | CC recipients of the draft email |
bcc | array<string> | Optional | BCC recipients of the draft email |
Requirements
Output
json— A dictionary containing the updated draft email detailsGoogle.UpdateEvent
Update an existing event in the specified calendar with the provided details. Only the provided fields will be updated; others will remain unchanged. `updated_start_datetime` and `updated_end_datetime` are independent and can be provided separately.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
event_id | string | Required | The ID of the event to update |
updated_start_datetime | string | Optional | The updated datetime that the event starts in ISO 8601 format, e.g., '2024-12-31T15:30:00'. |
updated_end_datetime | string | Optional | The updated datetime that the event ends in ISO 8601 format, e.g., '2024-12-31T17:30:00'. |
updated_calendar_id | string | Optional | The updated ID of the calendar containing the event. |
updated_summary | string | Optional | The updated title of the event |
updated_description | string | Optional | The updated description of the event |
updated_location | string | Optional | The updated location of the event |
updated_visibility | string | Optional | The visibility of the eventdefaultpublicprivateconfidential |
attendee_emails_to_add | array<string> | Optional | The list of attendee emails to add. Must be valid email addresses e.g., username@domain.com. |
attendee_emails_to_remove | array<string> | Optional | The list of attendee emails to remove. Must be valid email addresses e.g., username@domain.com. |
send_updates | string | Optional | Should attendees be notified of the update? (none, all, external_only)noneallexternalOnly |
Requirements
Output
string— A string containing the updated event details, including the event ID, update timestamp, and a link to view the updated event.Google.WriteDraftEmail
Compose a new email draft using the Gmail API.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
subject | string | Required | The subject of the draft email |
body | string | Required | The body of the draft email |
recipient | string | Required | The recipient of the draft email |
cc | array<string> | Optional | CC recipients of the draft email |
bcc | array<string> | Optional | BCC recipients of the draft email |
Requirements
Output
json— A dictionary containing the created draft email detailsGoogle.WriteDraftReplyEmail
Compose a draft reply to an email message.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
body | string | Required | The body of the draft reply email |
reply_to_message_id | string | Required | The Gmail message ID of the message to draft a reply to |
reply_to_whom | string | Optional | Whether to reply to every recipient (including cc) or only to the original sender. Defaults to 'GmailReplyToWhom.ONLY_THE_SENDER'.every_recipientonly_the_sender |
bcc | array<string> | Optional | BCC recipients of the draft reply email |
Requirements
Output
json— A dictionary containing the created draft reply email detailsGoogle.WriteToCell
Write a value to a single cell in a spreadsheet.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
spreadsheet_id | string | Required | The id of the spreadsheet to write to |
column | string | Required | The column string to write to. For example, 'A', 'F', or 'AZ' |
row | integer | Required | The row number to write to |
value | string | Required | The value to write to the cell |
sheet_name | string | Optional | The name of the sheet to write to. Defaults to 'Sheet1' |
Requirements
Output
json— The status of the operation