Zapier tutorial: Create a Zap to share video call recordings in Google Sheets

Update a Google Sheet whenever a new Daily.co video call recording has been created on your account.

In our [previous Zapier tutorial](https://www.daily.co/blog/zapier-tutorial-get-slack-notifications-for-new-video-call-recordings) we walked you through how to create a Zap with Slack that messages you whenever a video call has been recorded.

That post just scratched the surface of what you can do with Zapier. In this tutorial we will walk through how you can keep track of your video calls by creating a Zap that integrates with Google Sheets.

# Prerequisites

Of course, you'll need accounts with [Zapier](https://zapier.com/), [Daily.co](https://www.daily.co/) and [Google](https://google.com/). All of them are free, so sign up as needed.

# Step-by-step tutorial

1) Log in to your Zapier account and click on the **Make a Zap** button.

Click Make a Zap to get started :)

2) Next you'll connect Daily.co. **Note:** our app may still be pending approval for the public Zapier app store. You can still create your Zap! Just join our app via this invitation link, [https://zapier.com/developer/public-invite/10705/latest/](https://zapier.com/developer/public-invite/10705/latest/)
3) Create a Trigger by choosing the Daily.co app. You may need to search the App Store.

Choose the Daily.co app to create your Trigger.

4) Select the **New Recording** Trigger.

Our app has two Triggers, choose New Recording for the purpose of this tutorial

5) Connect your [Daily.co](http://dashboard.daily.co/) account with Zapier. This is very simple and free! We just need to get your API key, first. An API is a tool that lets you connect different services. Your Daily.co API key will alert Zapier when a new recording has been created. To get your key:
   - Login to your [Daily.co dashboard](https://dashboard.daily.co/) and copy your API key from the Developers tab.
   - In Zapier, click the **Connect an Account** and paste your API key and click to continue.

Connecting Daily.co with Zapier

6) Test your Trigger. Your Daily.co account must have a recording for this to work. See [Step 6](https://www.daily.co/blog/zapier-tutorial-get-slack-notifications-for-new-video-call-recordings) from our Zapier/Slack tutorial to learn how to quickly create a recording to test.
7) Add an Action Step by choosing Google Sheets from the App Store. Again, you may need to search to find the Google Sheets app.
8) Select the **Create Spreadsheet Row** Action. You can experiment with the other actions, yet we will update a row in an existing spreadsheet.

Choose the Create Spreadsheet Row action

9) Connect your Google Account.
10) Choose a Google Sheet to update and fill in the required fields. If you'd like, you can create a new sheet to update, or [make a copy of this spreadsheet](https://docs.google.com/spreadsheets/d/1W1JC8KhMvEbzzruomSy7chXJjc3V0CqIUIfa_HkM_nw/edit?usp=sharing).

Choose the Google Spreadsheet you'd like to update

11) Link the spreadsheet with the values from the [Daily.co](http://daily.co) API. Click on the menu icon to the right of each form and select the appropriate fields. If you are using the spreadsheet copy provided above, the fields are linked as follows (Google Sheet title → API endpoint):
   - Room name → Room name
   - Recording link → Download link
   - Call Duration → Duration
   - Number of Participants → Max Participants

Customize your spreadsheet by linking the Daily.co API

12) Test your Zap! Zapier will send a test to your Google Spreadsheet. If all goes well you should see a new row created in your spreadsheet.

Success! A spreadsheet updated via Zapier :)

13) Name and turn on your Zap!

---

That's it! Zapier may seem overwhelming at first, yet if you've followed the simple steps above you'll have a Google spreadsheet that is updated in the background whenever a Daily.co room is recorded.

What's next? Good question. Take what you've learned in this post and create a new Zap using our Zapier integration. We're excited about the powerful connections that Zapier offers users. As always, email us with any questions or comments.

Recent posts