How to Sync YouTube Analytics with Google Sheets Using Zapier

Quick summary

This tutorial shows how to sync YouTube Analytics with Google Sheets using a Zapier automation that triggers every time a new video is uploaded to your channel. Once set up, selected YouTube analytics data is automatically recorded as a new spreadsheet row — no manual data entry required.

Steps

1. Go to the left-side panel and click Create.
2. Select Zaps from the list of options.
3. Tap the Trigger tab to start the integration process.
4. Search for YouTube and choose it from the suggested results.
5. Click the Trigger Event menu to view available options.
6. Choose New Video in Channel as the trigger event.
7. Click Sign In and log into your YouTube account.
8. Click Allow to accept the terms and grant the necessary permissions.
9. Enter the name of the YouTube channel you want to track.
10. Click Continue to run your input and test the Trigger.
11. Click Continue one more time to proceed to the Action setup.
12. Search for Google Sheets and select it as the Action app.
13. Tap the Action Event menu to explore available options.
14. Select Create Spreadsheet Row or Create Spreadsheet Column.
15. Click Sign In and log into your Google account.
16. Click Allow to grant the necessary permissions for Google Sheets access.
17. Fill out the input fields for Google Drive, Spreadsheet, and Worksheet.
18. Choose the column where you want to add a new row and click the Add icon beside it.
19. Select the specific YouTube analytics data you want to monitor; repeat for additional fields.
20. Click Continue to publish and enable the integration.
21. The selected YouTube channel's analytics are now synced to Google Sheets automatically each time a new video is uploaded.