Google Sheets in Sync with DronaHQ Studio Sheets using Zapier

This article will show you how to keep Google sheets in sync with DHQ Sheets.

Prerequisite — You should have configured Zapier with the DronaHQ Studio account. If not, then refer to Configuring Zapier.

In this example, consider a use case where you will be using Google sheets for your daily needs, but at the same time, you want those details to be added in DronaHQ Sheets.

We will create a Zap with Google Sheet as a Trigger and DronaHQ as Action. Below are the steps that you can follow to achieve the same -

1. Login into Zapier.
2. Click on the Make a Zap option.
3. Under Choose App & Event option, search and select the “ Google Sheet” option.
4. Select Trigger as — “ New Spreadsheet Row”.

5. Under Choose Account, select or add your Google Account with the sheet you want to sync.

6. Select the spreadsheet and worksheet you want to sync with DronaHQ Sheet, as shown below.

7. You can either select “ Test & Review” or “ Test & Continue” or “ Skip Test”. Select “ Test & Continue”.

8. Google Sheet — New Sheet Row Trigger is configured successfully. Now, we need to connect this Google Sheet with DronaHQ Studio’s Sheet. Select the DronaHQ app and select “Create New Sheet Row” as an action shown below and click on Continue.

9. You can add an existing DronaHQ Account or add a DronaHQ Account using an API key, which has the DronaHQ Sheet to be in sync. You can find API Key under DronaHQ Studio Login -> Settings -> Integration -> API Key. Click on Continue.
For more information, you can refer to Using DronaHQ in Zapier.

10. Select the sheet name and configure all the columns of that sheet that will be synced. Add your DronaHQ Studio email ID. This email will appear under Created By column in Sheets when a row is created using this Zap.
Now, to connect the Google Sheet’s column to DHQ Studio Sheet, click on the + icon on the right side of the textbox and select the corresponding option from the dropdown as shown below.

Once all columns are configured as shown below, click on Continue.

11. You can either select “ Test & Review” or “ Test & Continue” or “Skip Test”. Select “ Test & Continue”.

12. Click on Done Editing and Click on “ TURN ZAP ON”.
Once the Zap is ON, a corresponding new row will be created in DHQ Studio Sheet whenever a new row is added above Google Spreadsheet.

Important Points to Note -

1. For Existing Data, you can either copy all the Data using CTRL+C (Windows) / CMD+C (Mac), and paste it into DronaHQ Sheet using CTRL+V (Windows) / CMD+V (Mac) OR you can download the CSV and in DronaHQ Studio create a new sheet and import this CSV.
2. Zapier polls Google Sheet data every 15 minutes, so there will be a maximum delay of 15 minutes for new row changes reflected in the DHQ Studio Sheet.
3. In the above example, we used the DronaHQ New Sheet Row action. For other actions, like update or other automated action, you can select the Initiate a Workflow option based on your need. In case you want to keep the Sheet in sync for updating rows, you will have to configure the Google Sheet trigger for “Insert or Update row” and in DronaHQ Studio action, “Initiate a Workflow” with workflow has Update Sheet Task configured as shown below. For updates, there has to be one unique Row Identifier to identify which row is updated. In the below example, the Name column is considered unique.

As you can see from the above image, if the data is not already added, then since “Insert new record, if doesn’t exist” is checked in the Update Sheet task, it will insert a new row. This will handle both New Row and Update Row scenarios.

4. Likewise, instead of Google Sheet, you can use any other 3rd party service and connect it with DronaHQ Studio using Zapier.

5. Existing Rows in Google Spreadsheet will not be triggered. Only new Rows added post creating this Zap will be triggered and available to DHQ Sheet.