.png){kind=icon}
Google Sheets
Integrate Google Sheets into your automation to simplify data manipulation. This extension provides robust tools for managing spreadsheets, rows, cells, and formatting, helping you streamline workflows that depend on dynamic data handling.
The Google Sheets FlowRunner Extension provides powerful tools for integrating and automating workflows with Google Sheets. This extension enables seamless management of spreadsheets, sheets, rows, cells, and data formats, making it an invaluable asset for efficient data handling. Supported actions include:
- Add Document: Create a new spreadsheet.
- Rename Document: Change the name of an existing spreadsheet.
- Delete Document: Permanently remove a spreadsheet.
- Add Sheet: Insert a new sheet into a document.
- Delete Sheet: Remove an existing sheet from a document.
- Rename Sheet: Update the name of a sheet within a document.
- Find Sheet: Locate a sheet based on specific criteria.
- Get Sheets List: Retrieve a list of all sheets in a document.
- Add Rows / Add Row: Insert one or multiple rows of data into a sheet.
- Get Rows / Find Row(s): Retrieve one or more rows based on specific conditions.
- Update Rows / Update Row: Modify data in one or multiple rows.
- Clear Rows or Cells Area / Clear Row: Erase content from specific rows or a defined cell area.
- Get Cell / Get Cell by A1: Retrieve the content of a cell, either programmatically or using A1 notation.
- Update Cell / Update Cell by A1: Modify the content of a cell, either programmatically or using A1 notation.
- Clear Cell / Clear Cell by A1: Erase the content of a cell, either programmatically or using A1 notation.
- Load Header Row / Set Header Row: Manage header rows to organize sheet data.
- Format Row: Apply formatting to a row.
- Export Sheet / Export Document: Download a specific sheet or an entire spreadsheet as a file.
- Copy Sheet to Document: Duplicate a sheet into another document.
- Import from CSV: Upload and populate data from a CSV file into a spreadsheet.
With this extension, you can streamline your Google Sheets workflows, enabling precision and efficiency in data management and reporting.
Install the Google Sheets FlowRunner Extension from the FlowRunner Marketplace to start integrating with your spreadsheets. After installation, add any Google Sheets action, such as Add Document or Get Rows, to the FlowEditor interface. Click the Login button to initiate the OAuth connection, granting secure access to your Google account. Once authenticated, you can seamlessly automate Google Sheets operations and data management tasks.
Backendless develops and supports the Google Sheets FlowRunner Extension. For assistance, visit the Backendless Support Forum to connect with our community and access resources to help you effectively use this extension. From configuration guidance to troubleshooting, we're here to ensure your automation success.
