Google Sheets is a powerful tool to streamline data management processes by automating row creation, updating, and deletion. Seamlessly integrate your Google Sheets documents within our workflow system, enabling efficient data management and reducing the risk of errors. Leverage lookup functionalities to locate specific rows, ensuring accuracy and providing a comprehensive solution for all your Google Sheets data needs.

Google Sheets Premium Workflow Action is a robust feature designed to enhance your data management experience within Google Sheets using the LC Premium Actions system. This powerful tool enables you to automate various tasks, such as creating, updating, and deleting rows, significantly improving your workflow efficiency and data accuracy.

Google Sheets Premium Workflow Action supports a range of actions, including creating new rows, updating specific rows, deleting rows, and more advanced features like updating or deleting rows using the lookup function. This comprehensive suite of actions ensures you have all the tools you need to manage your data in Google Sheets effectively.

The following Workflow actions are supported in Google Sheets.

Use this action to send data directly to a Google Sheets document

All your integrated Google accounts will be displayed in the dropdown menu for you to choose from.

Once you have selected a Google account from the dropdown menu in our subaccount system, all associated Google Drives will be displayed for you to choose from. This allows you to select the specific Google Drive account containing the target Google Sheets document you want to send data.

Once you have selected a Google Drive from the dropdown menu, all Spreadsheets associated with the integrated Google Drive will be displayed for you to choose from.

This allows you to select the specific Google Spreadsheet document to which you want to send data.

Once you have selected a Google Spreadsheet from the dropdown menu, all Worksheets inside that Spreadsheet will be displayed for you to choose from.

This allows you to select the specific Worksheet to which you want to send data.

When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row.

If you need to update the headers in the sheet, you can click the "Refresh Headers" button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations.

By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows.

You can insert value and create a new row in your Google Sheets document.

The "Update Specific Spreadsheet Row" action enables us to modify the contents of a specific row by specifying its row number. This action updates the values in the corresponding columns of that row.

Select a worksheet within your Spreadsheet that you wish to edit a row.

Specify the row number that you wish to modify in the Spreadsheet.

You may also provide the Row Number using the Custom Variable Picker to use dynamic values.

To update the desired columns, select the starting and ending columns.

You can leave it blank if you do not wish to update a particular column.

The "Delete Specific Spreadsheet Row" action enables us to delete the contents of a specific row by specifying its row number. This action will clear the values in all of the columns of that row.

Please Note:

Select a worksheet within your Spreadsheet that you wish to delete a row of.

Specify the row number that you wish to delete in the Spreadsheet.

Please Note:

The Google Sheet Lookup action allows you to look up data within your Google Sheets documents, providing you with a powerful tool for managing your data workflows.

Select a worksheet within your Spreadsheet that you wish to use for Looking up and retrieving data.

Select in which order the Google Sheet rows should be searched to find the matching row.

From the top of the Sheet - returns the first matching row

From the bottom of the Sheet - returns the most recent matching row

The first row is considered Headers, shown as labels for each Column. You can fetch the latest headers from the sheet by clicking "Refresh Headers".columncolumn

If an extra column is added, then both the Column's values should match to determine the matching row.

If enabled, it will execute Create Spreadsheet Row action when the lookup could not find any matching row at the time of execution. This action will be logged and charged separately.
​

Lookup Multiple Spreadsheet Row(s) is an extension to the Lookup Spreadsheet Row. Using this we can extract multiple rows. The configuration will be the same as Look Spreadsheet Row just with an addition of selecting the number of rows you want to extract.

The only difference is selecting the number of rows and that can be achieved by typing in the number of Rows in the "Row Count" field.

One of the advantages of using Lookup is that when you search for a particular row, all of its data can be saved as a custom value that can be utilized throughout your workflow.

Consider the following Worksheet as an example. If you need to search for a specific row, you can enter the contact phone number or email address in the lookup section. Once the lookup function finds the matching row, it will store all the values under the corresponding header name as custom variables.

When you add a Lookup action, an index is automatically generated. This index is essential for mapping the row data to the custom variables and allows for easy identification of multiple lookup values. Removing or editing the index once it is added is impossible.

The values obtained from the lookup action for a particular row can be used in all other activities within your workflows, just like any other contact fields or custom variables.

Please Note:

You can use {{sheet.x.rowNumber}} to get the row number of the lookup value.

Here x is the index of the lookup action.

Example:

The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below.

In If/Else:

Updating a spreadsheet row using Lookup involves searching for a specific row in your Spreadsheet based on a particular value using Lookup and then updating the values in that row with new data.

To update a specific row in a spreadsheet, you Should use Lookup Action to search for a column value in the data, which will return the corresponding row. Once you have located the desired row, you can use the "Update sheet using Lookup" Action to modify the data within that row.

Please Note:

This action will only display the Lookup actions added above it for selection.

To update the desired columns, select the starting and ending columns.

You can leave it blank if you do not wish to update a particular column.

Deleting a spreadsheet row using Lookup involves searching for a specific row in your Spreadsheet based on a particular value using Lookup and then deleting all the values in that row.

To delete a specific row in a spreadsheet, you Should use Lookup Action to search for a column value in the data, which will return the corresponding row. Once you have located the desired row, you can use the "Delete Spreadsheet Row using Lookup" Action to clear the data in the row.

Please Note:

Select Lookup Action

Only the Lookup Actions added above this action will be listed for selection.

If a row is returned during a lookup, all the values associated with that row will be cleared.