Do you want to know, the easiest way to send YouTube video data automatically to Google Sheets without knowing any coding skills?

How to Send YouTube Video Data Automatically to Google Sheets

If yes then continue following the step by step procedure given in this blog. As we are going to integrate YouTube with Google Sheets using Pabbly Connect. This is the simplest way out there on the internet and you’ll end up automating your tasks within a few clicks.

But first, let’s understand a little bit about the software that are involved here. As we all know YouTube is an online video-sharing platform that allows users to upload, view, rate, share, add to playlists, report, comment on videos, and subscribe to other users.

On the other hand, Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people. Therefore, by integrating these two services, you can easily add all the YouTube videos information to Google Sheets automatically.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect offers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect 

We are using Pabbly Connect for automating our task as it saves our time from doing repetitive work. This software is too easy-to-use that you can easily share data from multiple services in real-time. Moreover, you can access all the premium Pabbly Connect features such as instant triggers, multi-step calls & premium apps for unlimited workflows without any restriction even in the free plan.

How to Send YouTube Video Data Automatically to Google Sheets (step by step)

1. Sign up to Pabbly Connect

2. Access Pabbly Connect

3. Create WorkFlow

4. Setting Trigger

5. Connecting to YouTube

6. Capture the API Data

7. Test the Response

8. Setting Action

9. Connecting to Google Sheets

10. Check Response

Thereby, without further ado, let’s follow the step by step procedure to integrate YouTube with Google Sheets.

Step 1: Sign up to Pabbly Connect

Sign Up

Let’s commence the process to send YouTube video data automatically to Google Sheets by visiting the website of Pabbly Connect and then click on the ‘Sign-Up Free‘ button. On the registration page, either signup using an existing Gmail account or manually fill out the form.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect.

Step 3 : Workflow for YouTube with Google Sheets Integrations

(a) Create New Workflow

Create New Workflow

Start with creating a workflow for your project by clicking on the ‘Create Workflow’ button.

(b) Name the Workflow

Name the Workflow

Now, you need to name the workflow just like in the above-shown image. I named the workflow as “YouTube with Google Sheets”, you can obviously name the workflow as per your requirements and needs.

Step 4 : Setting Triggers for YouTube with Google Sheets Integrations

After naming your workflow, you have to select the application you want to integrate. Pabbly Connect allows you to integrate unlimited premium applications, create your free account now.

(a) Select Application you want to Integrate

Select Youtube

Now, you have to select the application that you want to integrate. In this case, we are choosing “YouTube” for integration. After selecting the application select “New Video in Channel” in the choose method section.

(b) Click Connect Button

Click Connect Youtube

After selecting the application, now you have to click on the “Connect with YouTube” button just like in the above-shown image to take further the integration process.

Step 5 : Connecting YouTube to Pabbly Connect

To connect YouTube with Pabbly Connect, you have to authorize your YouTube account, for that, you need to log in to your YouTube account.

(a) Click Connect Button

Connect Youtube Again

Once you click the connect button, a window will slide in from right, here you have to again click on the “Connect with YouTube” button to authorize application.

(b) Select Google Account

Choose Youtube Account

Next, you need to select a Google account through which you want to log in to your YouTube channel.

(c) Click Allow Button

Click Allow Button

Now simply click on the “Allow” button to connect to your YouTube channel.

Step 6 : Capture API Data

To check if the integration is capturing data or not, we will map the channel ID and send test request.

(a) Go to YouTube Settings

Click on Settings Youtube_censored

 

Click on your YouTube channel profile icon and then click on the “Settings” option.

(b) Copy the Channel ID

Click Advanced Settings

After reaching the settings page, click on the “Advanced Settings” option, and then copy the channel ID.

(c) Save and Send Test Request

How

Paste the copied channel ID and then click on the “Save and Send Test Request” button to capture the data.

Step 7 : Test the Submission in Pabbly Connect Dashboard

Save the API Response

As soon as you click on the “Save and Send Test Request” in Pabbly Connect the YouTube video entry will appear on the Pabbly Connect dashboard. Then, click on the “Save” option.

Step 8 : Setting Action for YouTube with Google Sheets Integrations

To complete this YouTube-Google Sheets integration, we will set an action for your trigger.

(a) Select Application you want to Integrate

Select Google Sheets

Now in this step, click on the + button below and choose “Google Sheets” and in the method section select “Add New Row”.

(b) Click on Connect Button

Click Connect Google Sheets

After choosing the application click on the “Connect with Google Sheets” button to move forward.

Step 9 : Connecting Google Sheets to Pabbly Connect

To connect Google Sheets with Pabbly Connect, you need to authorize your Google account, and for that, you need to login into your Google account.

(a) Authorize Application

Connect Google Sheets Again

To connect Google Sheets with Pabbly Connect, again click on the “Connect with Google Sheets” button to authorize the application. After clicking the button, select the Google account through which, you want to connect to Google Sheets.

(b) Map the Fields

How

Once you are connected with your Google account, now you have to add all the field data like sheet name, title of video, URL of video, etc. Map up all the fields quickly.

(c) Send a Test Request

How

Once you are done mapping up all fields click on the “Send Test Request” button.

Step 10 : Check Response in Google Sheets

How

Here, you can see that integration was successful and the video info from YouTube channel has been updated in Google Sheets automatically. Now in a similar way, whenever there will be any new video uploaded in your YouTube channel the info will be updated in your Google Sheets automatically.

Conclusion –

Well, this is all about “How to Send YouTube Video Data Automatically to Google Sheets”. Consequently, after completing the step by step procedure, you will end up adding YouTube video info to your Google Sheets automatically. The best part about this service is, it’s free, you don’t need to pay to work on it and the second thing is you don’t need any coding skills as well. Any newbie can handle this software easily.

Now, try Pabbly Connect for FREE for all its premium features.

For any further queries/suggestions, do comment below.

You May Also Like to Read –