Integrating Playbooks with Google Sheets offers a dynamic way to streamline your workflows. You can read and iterate over data in your sheets, export automation results as new rows, update existing entries, and even monitor your sheets for changes in real-time. This integration provides a powerful solution for automating your processes and increasing efficiency.
Get table from Google Sheet
Add rows to Google Sheet
Update Google Sheet rows
When row is added or updated in a Google Sheet
If you haven't connected your Google Sheets account to Bardeen yet, the system will prompt you to authenticate the connection. Simply follow the wizard and grant the necessary permissions to proceed.
Get table from Google Sheet
Whether you need to scrape links from a column in a Google Sheet or analyze each row with AI, you can connect your sheet using the "Get table from Google Sheet" action. Find this action in "Actions & Triggers" and add it to builder.
Here are the options for connecting a sheet:
-
Select a specific sheet: The same Google Sheet will be used every time the automation runs. To select a specific sheet, start typing its name, and you’ll see a list of options to choose from.
-
Create an argument for a sheet value: If you choose "Ask me every time" the automation wizard will prompt you to select a sheet each time it runs. This allows you to use the same automation with different Google Sheets, but in order to read from a specific column, you will need to add action "Get column from a table".
Selecting a tab is optional. If you do not choose a specific tab, the automation will read data from the first tab in your sheet by default.
If you've selected a specific sheet, you can directly connect the subsequent actions of your automation to the columns of that sheet directly.
Add rows to Google Sheet
Whether your automation involves scraping data from the web or generating an AI summary of text, you can export the results as Google Sheet rows.
Find "Add rows to Google Sheet" in Actions & Triggers and add it to builder space. The next step is to choose a sheet and there are options:
-
Select a specific sheet: The same Google Sheet will be used every time the automation runs. To select a specific sheet, start typing its name, and you’ll see a list of options to choose from.
-
Create an argument for a sheet value: If you choose "Ask me every time" the automation wizard will prompt you to select a sheet each time it runs. This allows you to use the same automation with different Google Sheets.
Selecting a tab is optional. If you do not choose a specific tab, the automation will read data from the first tab in your sheet by default.
Fields mapping
Update Google Sheet rows
This action allows you to find rows in a Google Sheet by checking the values in a selected column and updating them with automation data. Here’s how to configure the search:
If a specific Google Sheet has been selected, choose the column that contains unique values to serve as the search column. For example, if your automation is scraping links, select the column that contains those links.
-
- Find rows by value: This involves searching for a unique value within the selected column. Map this to the corresponding step in the automation.
If a Google Sheet was not specified and you selected "Ask me every time" the automation will not be able to provide a list of columns to choose from. In this case, add the "Get column from a table" action to your automation and select its value as the search column.
-
- The Find rows by value action should also be connected to the same "Get column from a table" action.
When row is added or updated in a Google Sheet
The "When a row is added or updated in a Google Sheet" action triggers an automation whenever a new row is added or an existing row is updated in the selected sheet. This allows you to automate tasks based on changes in your Google Sheet in real time.
Similar to Get table from Google Sheet, this action will fetch a table from a Google Sheet. There are additional settings that allow to configure connected table as a trigger for the automation:
-
Using id columns: columns to use as unique identifiers for the sheet data. Leave empty if there are no unique identifiers.
-
Limit to: start autobook only when a row is updated OR only when a row is added.
Note: If Limit to is not set, the entire table will be pushed through the automation.
Comments
0 comments
Please sign in to leave a comment.