Quartzy users can now sync data from their Quartzy lab to Google Sheets for easy tracking, sharing between teams, managing multiple labs data in one place, and more.
Some common use-cases are:
- Tracking lab expenses
- Tracking order deliveries
-
Inventory tracking and auditing
- Data backup (sync deleted items to Sheets)
- Managing multiple labs
Read below to learn how to utilize webhooks and Zapier, a workflow automator, to configure this integration for your lab!
Requirements:
- Google Sheets
- Quartzy: Lab Admin role
- Zapier: Professional, Team, or Company subscription plan
In the following example, we will set up an expense tracking sheet, but the process is easily customizable so you can select the options relevant to your lab's use-case.
To get started, download the following file, then import it to Google Sheets: Quartzy > Google Sheets
Navigate to the first sheet, Requests / Expenses Tracking. The column headers represent the data for each request that can sync from Quartzy.
If there's any data which your lab does not want to track on your Google Sheet, simply delete the relevant column(s)
Next, login to your Zapier account, click the orange Create button, and select the Zaps option.
You'll be taken to the following page:
Trigger
1. Click the Trigger section, and select the Webhooks by Zapier option
2. Next, select Catch Hook from the Event dropdown menu, then click Continue
3. For Trigger, click Continue - no action needed
4. Copy the URL under "Your webhook URL" to your clipboard or notes app
5. In your Quartzy account, locate the lab you want to integrate with Sheets, and navigate to Manage Labs > Developers. Click the Add webhook button.
6. Name your webhook, paste the URL you copied from Zapier into the URL field, and select the Event Type relevant to your use-case.
For this example, we're selecting Order request ordered, so that requests will sync to our sheet when they're marked as Ordered in Quartzy.
Select the checkbox next to Set null values to an Empty String?
Click Save.
7. For testing purposes, create a fake request or inventory item, and perform the action of the Event Type(s) you selected. For example, if you selected Order Request Ordered, add a test (non-QuartzyShop) request, and mark it as Ordered.
8. Back in Zapier, click the Test Trigger button. It will return a "We found a request!" message.
Note: it can take up to two minutes for the trigger to be recognized. If your first test fails, please wait 1-2 minutes and then try again.
Click Continue.
Tip: if testing the trigger fails, make sure you created your fake request or inventory item in the correct lab.
Action
1. Click on the Action section
2. Select the Google Sheets app
3. Select Create Spreadsheet Row from the Event dropdown menu, then click Continue
4. Select your Google Sheets account, then click Continue
5. Select the appropriate Google Drive, Spreadsheet, and Worksheet to which you want Quartzy to send data. Once selected, each column header from your Google Sheet will appear as a field in Zapier.
6. Select the appropriate value(s) for each field, and then click Continue.
7. Click the Test action button, then check your Google Sheet - there should be a newly created row with your request (or inventory item) details.
8. If everything looks good, click the Publish Zap button to activate the data syncing from Quartzy to your Google Sheet. That's it! Going forward, information will be synced directly to your Google Sheet automatically.
Comments