Skip to main content

Google Sheets

Google Sheets and DronaHQ integration is an easy and assured go-to solution to build user interfaces over the structured data storage that is the power of Google sheets.

Configuring API Connector in DronaHQ

Add a Account name. Then click Save, it will open a pop-up window asking you to sign-in into your Google account. Continue with the steps and give access to DronaHQ to connect with your Google for its Sheets ID and information.

Sign-in to your Google account
Sign-in to your Google account

After successfully configuring and saving the connector settings, you can easily access your newly connected account by navigating to the connected accounts list. You can find this option from the Connector -> Manage Account section. This centralized location allows you to conveniently monitor and manage your connected accounts.

Supported API endpoints

ActionDescription
GetAllRowsV2Retrieve all rows from a specific sheet in a Google Sheets document.
FindRowsV2Search and retrieve rows from a specific sheet based on specified criteria.
GetAllSheetsGet a list of all sheets within a Google Sheets document.
GetSheetDetailsRetrieve details and properties of a specific sheet.
CreateSheetCreate a new sheet within a Google Sheets document.
GetAllRowsRetrieve all rows from a specific sheet in a Google Sheets document.
AddRowsAdd new rows to a specific sheet in a Google Sheets document.
Find RowsSearch and retrieve rows from a specific sheet based on specified criteria.
UpdateRowUpdate the content of a specific row in a Google Sheets document.
Clear RowClear the content of a specific row in a Google Sheets document.
Find a RowSearch and retrieve rows from a specific sheet based on specified criteria.
AddMultipleRowsAdd multiple rows to a specific sheet in a Google Sheets document.
FindDriveFilesSearch and retrieve Google Drive files related to Google Sheets.
GetSingleRowRetrieve a single row from a specific sheet based on row number.
ClearMultipleRowsClear content from multiple rows in a Google Sheets document.
UpdateMultipleRowsUpdate content in multiple rows within a Google Sheets document.

Using Google Sheets Connector

Get all rows

To fetch all rows matching criteria you can use the GetAllRows connector. To configure fields you can provide the dynamic values using the keywords. You can add variables to return a response value to this connector. There are several Output values returned which can be used as required.

In this example shown below, will first fetch all the rows matching the Search Value which is a dynamic value provided using the keywords.

  1. Use variables to fetch the data from column B for the searched rows. You can see here that we have also used the Row number as well as a return value. These Row number values can be used in other use cases or scenarios like updating rows, deleting rows based on certain conditions, and so on.

    Configuring fields to do multiple row clearing.
  2. While using GetAll Rows in Google Sheets the response had fixed keys values.A and values.B and so on. DronaHQ has introduced a new enhanced feature Use Header Rows option that replaces the fixed keys with headings in your sheets.

  3. For the GetAll Rows option, you provide the required inputs, and view the result with fixed keys B and C.

Configuring fields to do multiple row clearing.

In the above example we can view fixed keys B and C whereas the headings of the google sheets action-name, type and so on are viewed as rows.

  1. Now change the Use Header Row in Response to True/Yes. Click Refresh Response you will be able to view this screen.
Configuring fields to do multiple row clearing.

Get Single Row

To fetch the row details of a specific row number provided by the user can be done by using the GetSingleRow subcategory of the Google Sheet API connector. You just have to select the subcategory and provide the sheet details such as the spreadsheet name and sheet ID along with the row number. These details will be used to fetch the row details of a specific row number from a certain spreadsheet.

Configuring fields to do multiple row clearing.

You can add this connector in the data bind section or action of any control. Select the columns to bind in the control as keys. We will be using table grid control to view the data received by the API subcategory.

Configuring fields to do multiple row clearing.

Clearing multiple rows

The Clear multiple rows option comes to help when you want to clear multiple rows to Google Sheets. You can use data from tablegrid control for instance to clear data to your google sheet.

Pass an array of rows’ numbers in the method along with the spreadsheet name and its sheet name.

Configuring fields to do multiple row clearing.
Configuring fields to do multiple row clearing.