By using Flows, users can create automated workflows that integrate Google Sheets. For example, you can set up a Flow to automatically add rows to a Google Sheet from new entries in a form or transfer data from Google Sheets to another service when an update is made.
Some common automations include updating spreadsheets with new data entries, synchronizing spreadsheet data with other databases, or triggering emails based on spreadsheet changes.
By connecting Google Sheets with Flows, users can simplify and automate repetitive tasks, improving efficiency and decreasing the likelihood of errors from manual data entry.
Add an Action in Flows and choose the Google Sheets Application.
Choose the desired Event group and Event name from the available list
Then choose “Create new connection”. or “Select connection “( if you have already created it in another step or Flow)
Start action input setup based on each event specific options
Test action /Save
Continue to next step or Publish the Flows
How to “Create new connection” for Google Sheets?
To use Google Sheets in one or more of your Flows, you must have a connection to your Google account.
Once you click on “Create new connection”, the next step is to choose your Google account (where you have the Google Sheets that you want to use).
You are then informed by Google that you are establishing a connection with Flows. You may find out more regarding the Privacy Policy and Terms of Use. When you are ready, press Continue to move to the next step.
Next, you are informed about what kind of permissions you are giving to Flows.
Once you choose Allow, the connection between Flows and your Google account will be established.
Your connection will appear in Flows.
Note: this connections is created is private to yourself. sharing it with other team members, gives them access to your Google sheets, as if they were signed in with your account. In case some team-member needs to use a file you own in Google, share it inside Google and instruct them to create their own connection with own Google account.
“ Select connection” for Google Sheets
In case you have already defined your Google Account Connection, you have the option to choose it from the Connections list by clicking on “Select connection“
List of available events for Google Sheets
The Google Sheets Application allows you to make the following actions
Append Row
Fetch Rows
Append Row
With this action you may append a single row into a spreadsheet.
After you create or select your Google Account connection and select your spreadsheet, you may select the worksheet where you want to append a row.
Flows interprets data from the first row of the selected worksheet as column headers.
These are used to label the columns in Flows.
For this action you may select what data to go into each identified column. The data can be manually input or returned from previous steps.
When you select an empty worksheet, Flows will find no labels for the columns. It will then allow you to input a row, as an array of values. (list of values of your choice in the order they are received)
Once you press Save & test, a new row will appear after the last row where you have data in the selected worksheet.
Fetch Rows
After you create or select your Google Account connection and select your spreadsheet,, this action may be used to fetch rows from a Google spreadsheet. By default, the data from rows 1 to 10, included in columns A to Z is read. You may customize the range of cells from where data is fetched using the Range input parameter.
The fetched data will be available in the output of this action. You may use it in other steps of your Flow.
How to Work with Google Sheets in Flows
Search Spreadsheets
When you want to select a Spreadsheet, Flows will by default load the first most recently modified 45 spreadsheets, available via the given Google connection.
You may refresh the list of returned spreadsheets by using the Refresh results button.
In case you are searching for a particular spreadsheet, you may type one or more words in the Search box. Only spreadsheets containing your search term in their name will be retrieved. They will be ordered by their last viewed time, starting with the most recent.
Searching will be done on the loaded and unloaded results. This means that Flows will search in all spreadsheets (those that are already loaded and those which were not loaded).
When there is no search term provided, Flows will apply its default loading mechanism.
Important
Flows can access only Google Sheet files. Excel files (.xlsx) are not available to Flows. However, you can convert them automatically to Google Sheet files using Google Drive. See more details here