forked from Significant-Gravitas/AutoGPT
56 lines
2.2 KiB
Markdown
56 lines
2.2 KiB
Markdown
## Google Sheets Read
|
|
|
|
### What it is
|
|
A block that reads data from a Google Sheets spreadsheet.
|
|
|
|
### What it does
|
|
This block retrieves information from a specified range within a Google Sheets spreadsheet.
|
|
|
|
### How it works
|
|
The block connects to Google Sheets using provided credentials, then fetches data from the specified spreadsheet and range.
|
|
|
|
### Inputs
|
|
| Input | Description |
|
|
|-------|-------------|
|
|
| Credentials | Authentication information required to access Google Sheets |
|
|
| Spreadsheet ID | The unique identifier of the spreadsheet you want to read from |
|
|
| Range | The specific area of the spreadsheet you want to read (e.g., "Sheet1!A1:B2") |
|
|
|
|
### Outputs
|
|
| Output | Description |
|
|
|--------|-------------|
|
|
| Result | The data retrieved from the spreadsheet, organized in rows and columns |
|
|
| Error | Any error message that occurred during the process |
|
|
|
|
### Possible use case
|
|
A marketing team could use this block to automatically retrieve the latest campaign performance data from a shared Google Sheets document for analysis and reporting.
|
|
|
|
---
|
|
|
|
## Google Sheets Write
|
|
|
|
### What it is
|
|
A block that writes data to a Google Sheets spreadsheet.
|
|
|
|
### What it does
|
|
This block allows you to input data into a specified range within a Google Sheets spreadsheet.
|
|
|
|
### How it works
|
|
The block authenticates with Google Sheets using provided credentials, then updates the specified spreadsheet range with the given data.
|
|
|
|
### Inputs
|
|
| Input | Description |
|
|
|-------|-------------|
|
|
| Credentials | Authentication information required to access Google Sheets |
|
|
| Spreadsheet ID | The unique identifier of the spreadsheet you want to write to |
|
|
| Range | The specific area of the spreadsheet where you want to write data (e.g., "Sheet1!A1:B2") |
|
|
| Values | The data you want to write to the spreadsheet, organized in rows and columns |
|
|
|
|
### Outputs
|
|
| Output | Description |
|
|
|--------|-------------|
|
|
| Result | Information about the write operation, such as the number of cells, columns, and rows updated |
|
|
| Error | Any error message that occurred during the process |
|
|
|
|
### Possible use case
|
|
An automated inventory system could use this block to update stock levels in a Google Sheets spreadsheet whenever products are sold or restocked, ensuring real-time inventory tracking. |