# Google Sheets Google Sheets is a cloud-based spreadsheet application that enables users to create, edit, and share spreadsheets from any device. It offers real-time collaboration, powerful data analysis tools, and seamless integration with other Google services. ### **How to Integrate Google Sheets with ZBrain Flow** To integrate Google Sheets with ZBrain Flow: 1. Click the ‘+’ button in ZBrain Flow. 2. Type "Google Sheets" in the search bar and select it from the available options. 3. Choose an action to begin the setup process. ### **How to Connect Google Sheets to ZBrain Flow** To establish a connection between Google Sheets and ZBrain Flow: 1. **Enter a Connection Name** – Provide a name for easy identification. 2. **Click ‘Connect’** – Start the authentication process. 3. **Log in to Google Sheets** – A pop-up window will appear for Google login. 4. **Grant Permissions** – Approve the required permissions to allow ZBrain Flow access. 5. **Save the Connection** – Click **‘**Save**’** to finalize the setup. Once connected, ZBrain Flow can interact with Google Sheets to retrieve, update, delete, and automate spreadsheet operations. ### **Where to Find Spreadsheet ID, Sheet ID, and Parent Folder in Google Sheets** 1. **Spreadsheet ID:** * Open your Google Sheet in a browser. * Look at the URL in the address bar. The Spreadsheet ID is the long alphanumeric string between `/d/` and `/edit`. * Example: `https://docs.google.com/spreadsheets/d/1A2B3C4D5E6F7G8H9I0J123456789abcdef/edit#gid=0` * The Spreadsheet ID is `1A2B3C4D5E6F7G8H9I0J123456789abcdef`. 2. **Sheet ID:** * Each tab in a spreadsheet has a unique Sheet ID. * Find it at the end of the URL after `#gid=`. * Example: `https://docs.google.com/spreadsheets/d/1A2B3C4D5E6F7G8H9I0J123456789abcdef/edit#gid=123456789` * The Sheet ID is `123456789`. 3. **Parent Folder (For Creating a New Spreadsheet in a Specific Folder):** * Open Google Drive. * Navigate to the folder where you want to create a new spreadsheet. * Copy the folder ID from the URL (the alphanumeric string after `/folders/`). * Example: `https://drive.google.com/drive/folders/1B2C3D4E5F6G7H8I9J0K` * The Parent Folder ID is `1B2C3D4E5F6G7H8I9J0K`. ### **Switch Descriptions in Google Sheets Actions** | **Switch Name** | **Description** | | --------------------------------------- | --------------------------------------------------------------------------------------------------------------------- | | **Include Team Drive Sheets?** | Includes spreadsheets from Google Team Drives (shared drives) in actions. | | **As String** | Inserts values (dates and formulas) as plain text instead of processing them. | | **Does the first row contain headers?** | Treats the first row as column headers for mapping data. | | **Overwrite Existing Data?** | Replaces all existing data in the sheet with new input data. | | **Avoid Duplicates?** | Checks for duplicate values before inserting new rows, ensuring only unique entries are added. | | **Exact Match?** | Searches for an exact match of the specified value instead of partial matches. | | **Is First Row Headers?** | Specifies whether the first row contains headers to properly format data retrieval. | | **Memory Key** | Stores the last processed row number, allowing the automation to resume from the correct position in subsequent runs. | ### **Actions Available in ZBrain Flow** #### **1. Insert Row** The Insert Row feature allows users to append a row of values to an existing Google Sheet, enabling seamless data entry and automated record keeping. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the Spreadsheet ID:** Provide the unique identifier of the target spreadsheet. 4. **Enter the Sheet ID:** Specify the ID of the worksheet within the spreadsheet. 5. **As String:** Enable/Disable this switch to determine if inserted values that are dates and formulas will be entered as strings without being evaluated. 6. **Does the first row contain headers?:** Enable/Disable this switch to indicate if the first row contains column headers. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **2. Insert Multiple Rows** The Insert Multiple Rows feature enables users to add one or more new rows to a specific spreadsheet, facilitating batch data entry and automated data population. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the Spreadsheet ID:** Provide the unique identifier of the target spreadsheet. 4. **Enter the Sheet ID:** Specify the ID of the worksheet within the spreadsheet. 5. **Enter the rows input format:** Select the format of the input values to be inserted into the sheet. Choose between CSV, JSON, or column names. 6. **Overwrite Existing Data?:** Enable/Disable this switch to replace all existing data in the sheet with new data from your input. This will clear any extra rows beyond the updated range. 7. **Avoid Duplicates?:** Enable/Disable this switch to check for duplicate values before inserting data into the sheet. Only unique rows will be added based on the selected column. 8. **As String:** Enable/Disable this switch to determine if inserted values that are dates and formulas will be entered as strings without being evaluated. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **3. Delete Row** The Delete Row feature allows users to remove a specific row from an existing sheet, enabling data cleanup and automated record management. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the Spreadsheet ID:** Provide the unique identifier of the target spreadsheet. 4. **Enter the Sheet ID:** Specify the ID of the worksheet within the spreadsheet. 5. **Enter the Row number to remove:** Specify the exact row number to be deleted from the sheet. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **4. Update Row** The Update Row feature enables users to overwrite values in an existing row, allowing for data modifications and corrections within automated workflows. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the Spreadsheet ID:** Provide the unique identifier of the target spreadsheet. 4. **Enter the Sheet ID:** Specify the ID of the worksheet within the spreadsheet. 5. **Enter the Row number to update:** Specify the exact row number to be updated. 6. **Does the first row contain headers?:** Enable/Disable this switch to indicate if the first row contains column headers. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **5. Find Rows** The Find Rows feature allows users to locate specific rows in a Google Sheet based on column values, enabling data retrieval and conditional processing. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the Spreadsheet ID:** Provide the unique identifier of the target spreadsheet. 4. **Enter the Sheet ID:** Specify the ID of the worksheet within the spreadsheet. 5. **Enter the name of the column to search in:** Specify which column should be examined for the search value. 6. **Enter the search value:** Provide the value to search for in the specified column. If left empty, all rows will be returned. 7. **Exact match:** Enable/Disable this switch to determine whether to choose rows with an exact match or rows that contain the search value. 8. **Enter the starting row:** Specify the row number to start searching from. 9. **Enter the number of rows:** Specify how many matching rows to return. The default is 1 if not specified. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **6. Create Spreadsheet** The Create Spreadsheet feature enables users to generate a new blank spreadsheet, facilitating the creation of new data repositories within automated workflows. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Enter the title of the new spreadsheet:** Provide a name for the new spreadsheet. 3. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 4. **Enter the parent folder:** Specify the folder to create the worksheet in. By default, the new worksheet is created in the root folder of the drive. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### 7. Create Worksheet The Create Worksheet feature allows users to add a new blank worksheet to an existing spreadsheet, enabling organized data management across multiple tabs. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet:** Provide the ID of the target spreadsheet. 4. **Enter the title of the new worksheet:** Specify a name for the new worksheet. 5. **Enter the headers:** Define column headers for the new worksheet. Click on '+ Add Item' to add more headers. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **8. Clear Sheet** The Clear Sheet feature enables users to remove all data from an existing worksheet, facilitating data refresh and cleanup operations. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet:** Provide the ID of the target spreadsheet. 4. **Enter the ID of the sheet to use:** Specify the worksheet ID to be cleared. 5. **Is First row Headers?:** Enable/Disable this switch to indicate if the first row contains column headers that should be preserved. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **9. Get Row** The Get Row feature allows users to retrieve a specific row from a Google Sheet by its row number, enabling targeted data extraction and processing. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet:** Provide the ID of the target spreadsheet. 4. **Enter the ID of the sheet to use:** Specify the worksheet ID to retrieve data from. 5. **Enter the row number to get from the sheet:** Specify the exact row number to retrieve. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **10. Get Next Rows** The Get Next Rows feature enables users to retrieve batches of rows sequentially from a Google Sheet, facilitating pagination and processing of large datasets. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet:** Provide the ID of the target spreadsheet. 4. **Enter the ID of the sheet to use:** Specify the worksheet ID to retrieve data from. 5. **Enter the Start row:** Specify the row number to begin retrieval from. 6. **Enter the memory key:** Provide a key used to store the current row number in memory. 7. **Enter the group size:** Specify the number of rows to retrieve in each batch. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **11. Find Spreadsheets** The Find Spreadsheets feature allows users to locate spreadsheets by name, enabling dynamic selection of data sources within automated workflows. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet name:** Provide the name of the spreadsheet to search for. 4. **Exact Match:** Enable/Disable this switch to determine if only spreadsheets exactly matching the name should be returned or if spreadsheets containing the name should be included. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **12. Find Worksheets** The Find Worksheets feature enables users to locate specific worksheets within a spreadsheet by title, facilitating dynamic data operations across multiple tabs. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet:** Provide the ID of the target spreadsheet. 4. **Enter the title:** Specify the title of the worksheet to search for. 5. **Exact Match:** Enable/Disable this switch to determine if only worksheets exactly matching the title should be returned or if worksheets containing the title should be included. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **13. Copy Worksheet** The Copy Worksheet feature allows users to duplicate an existing worksheet within the same spreadsheet or another, enabling template reuse and data backup. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet containing the worksheet to copy:** Provide the ID of the source spreadsheet. 4. **Enter the spreadsheet to paste in:** Specify the ID of the destination spreadsheet. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **14. Update Multiple Rows** The Update Multiple Rows feature enables users to modify multiple rows in a spreadsheet simultaneously, facilitating batch updates and data transformations. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet ID:** Provide the unique identifier of the target spreadsheet. 4. **Enter the sheet ID:** Specify the ID of the worksheet within the spreadsheet. 5. **As String:** Enable/Disable this switch to determine if inserted values that are dates and formulas will be entered as strings without being evaluated. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **15. Create Spreadsheet Column** The Create Spreadsheet Column feature allows users to add a new column to an existing worksheet, enabling data structure expansion and additional data capture. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Include Team Drive Sheets:** Enable/Disable this switch to determine if sheets from Team Drives should be included in the results. 3. **Enter the spreadsheet ID:** Provide the unique identifier of the target spreadsheet. 4. **Enter the sheet ID:** Specify the ID of the worksheet within the spreadsheet. 5. **Enter the column name:** Provide a name for the new column. 6. **Enter the column index:** Specify the position for the new column. * The column index starts from 1. For example, if you want to add a column to the third position, enter 3. * If the input is less than 1, the column will be added after the last current column. **Note:** Click *'f'* to insert dynamic values for flexible configurations. #### **16. Custom API Call** The Custom API Call feature enables users to interact directly with the Google Sheets API, allowing for advanced operations and custom integrations beyond standard actions. **Configuration Steps:** 1. **Select an Existing Connection or Create a New One:** Choose an existing connection or establish a new one. 2. **Enter the URL:** You can use the full URL or the relative path to the base URL. 3. **Select the HTTP Method:** Choose the request type that aligns with your action: * **GET** – Retrieve file or folder details. * **POST** – Upload new files or create folders. * **PATCH** – Modify file metadata or update folder permissions. * **PUT** – Replace existing content in a file. * **DELETE** – Remove a file or folder permanently. * **HEAD** – Fetch response headers only without retrieving the actual data. 4. **Add Headers:** Define any additional headers required for the API request. Authorization headers are automatically injected. Click '+ Add Item' to include more headers. 5. **Add Query Parameters:** Customize API requests with query parameters to filter results or specify additional options. Click '+ Add Item' to add more parameters. 6. **Enter JSON Body:** Provide structured request data in JSON format. 7. **Set Timeout (in Seconds):** Define the request timeout duration to prevent long-running API calls from stalling the process. **Note:** Click *'f'* to insert dynamic values for flexible configurations.