Video Marketing Automation using Zapier and Rocketium

As a digital marketer, you need automation. Video marketing has already been established as an effective way for brands and businesses to boost their online presence. If your marketing team is churning out many videos in a day, tracking daily metrics, making reports, and even manually putting them up on social is NOT how a digital marketer should spend their time. Just automate it, mate!

Why do digital marketers need automation?

In short, you need automation so you don’t end up pulling your hair apart.

Making reports, updating sheets, posting stuff on social – these tasks are time-consuming and add minimal value to you as a person.

Without automation, you do these repetitive tasks, leaving almost no time for being creative. At that moment, you become a robot, because what makes you human is stripped away from you – innovation and creativity.

On the other hand, if you automate these repetitive tasks and rather spend your time analyzing the reports or creating a marketing distribution plan, you become a successful digital marketer.

But enough of philosophy. Let us delve in to discuss what you really came here for.

Video Marketing Automation

In this guide, I will be explaining how you can automate your video marketing efforts. At the end of this, you will learn how videos can be shared automatically on social media platforms like Facebook and YouTube, and video hosting platforms like Wistia.

Tools used in this guide:

You can create a Zapier account here. To sign up for Rocketium, visit this link. And to get started with Buffer, you can click here.

Overview

Here is an overview of the topics I have covered in this guide.

  • How to automate video sharing to Facebook
  • How to automate video uploading to YouTube
  • How to add a video to Google Drive automatically
  • How to automate video uploading to Wistia
How to automate video sharing to Facebook

How to automate video sharing to Facebook

Videos created in a Rocketium powered Google Spreadsheet can be automatically posted to Facebook using a Zapier integration.

Step 1: Make a Zap on Zapier

Create a two-step Zap connecting the apps ‘Google Sheets’ and ‘Facebook Pages’.

Creating a Zap with Google Sheets and Facebook Pages

Step 2: Select a trigger for Google Sheets

Select the preset trigger: ‘New or Update Spreadsheet Row’.

Choose the Google account in which the spreadsheet to be linked is stored .

Pick the spreadsheet and worksheet with the videos from the drop-down list.

Map the ‘Trigger Column’ to ‘Video Link’ column. This means that every time a new URL is added or updated in the ‘Video Link’ column, the action of posting to Facebook is triggered.

Step 3: Select an action for Facebook Pages

Choose the preset action, ‘Create Page Video’.

Link your Facebook account to Zapier.

Pick your Facebook page from the drop-down. Select the row ‘Video Link’. You can also link the ‘Title’ and ‘Description’ columns in the Google Spreadsheet. These are optional fields, btw.

Step 4: Test your Zap and set it live

You can test the Zap and as soon as you switch it on, every time a video is added to the Google Spreadsheet, the video will be posted to your Facebook Page.

How to automate video uploading to YouTube

How to automate video uploading to YouTube

Videos created in a Rocketium powered Google Spreadsheet can be automatically uploaded to YouTube using a Zapier integration.

Step 1: Make a Zap on Zapier

Create a two-step Zap connecting the apps ‘Google Sheets’ and ‘YouTube’.

Step 2: Select a trigger for Google Sheets

Select the preset trigger ‘New or Updated Spreadsheet Row’.

Link your Google account with Zapier.

Pick the spreadsheet and worksheet with the videos from the drop-down list.

Set the trigger column to ‘Video Link’. This means every time a new URL is added or updated in the ‘Video Link’ column, it will be shared to YouTube.

Step 3: Select a action for Youtube

Select the preset action ‘Upload Video’.

Link your Youtube account to Zapier.

Link the Title, Description and Video column in the Google Spreadsheet.

Note: To schedule your posts from the Google Spreadsheet itself, change the privacy status to ‘Private’ and link the ‘Date’ and Time’ fields from the spreadsheet to ‘Publish at’.

Step 4: Test your Zap and set it live

You can test the Zap and as soon as you switch it on, every time a video is added to the Google Spreadsheet, your video is uploaded to YouTube.

How to save a video to Google Drive automatically

Videos created in the Rocketium powered Google Spreadsheet can be automatically uploaded to a Google Drive folder using Zapier.

Step 1: Make a Zap on Zapier

Create a two-step Zap by connecting ‘Google Sheets’ and ‘Google Drive’

Step 2: Select a trigger for Google Sheets

Select the preset trigger: ‘New or Updated Spreadsheet Row’

Connect your Google account to Zapier.

Pick the relevant Google Spreadsheet from the drop-down.

Map the trigger column to the ‘Video Link’ column. This will upload a video to your Google Drive every time a new URL is added or updated in the ‘Video Link’ column.

Step 3: Select an action for Google Drive

Select the preset action ‘Upload File’.

Link your Google Drive account to Zapier.

Pick the folder where you want the video file to save.

Select ‘Video Link’ from the drop down.

Step 4: Test your Zap and set it live

Test the Zap and when you switch it on, every time a video link is added to the Google Spreadsheet, the video file will be uploaded to the selected Google Drive folder.

How to automate video uploading to Wistia

Videos created using the Google Spreadsheet can be uploaded to Wistia through Zapier.

Step 1: Make a Zap on Zapier

Create a two-step Zap by connecting ‘Google Sheets’ and ‘Wistia’

Step 2: Set a trigger for Google Sheets

Select the preset trigger: ‘New or Update Spreadsheet Row’.

Connect your Google account to Zapier.

Map the ‘Video URL’ column to the trigger column

Step 3: Select an action on Wistia

Select the preset action: ‘Upload Video’ on Wistia.

Connect your Wistia Account to Zapier. To do this, you need a Wistia access key. This can be found in your Wistia Account.

Just go to Account > Settings > API Access and copy the access code.

Select a project from your Wistia dashboard and paste the video URL from the Google Spreadsheet.

Step 4: Test your Zap and set it live

Test the Zap and when you switch it on, every time a video link is added to the Google Spreadsheet, the video file will be uploaded to the selected project in Wistia.

Conclusion

Automation plays an important role in a digital marketer’s life. And as days pass by, video marketing is proving to be an effective way to grow a business exponentially.

By automating video marketing, you eliminate the need to do menial tasks and save up time to build strategies, run experiments, analyse results, and come up with a winning formula for video marketing!

Pulkit Jain

Pulkit Jain

Engineer • Marketer • Tech Geek • Movie & Comic book nerd • Avid reader • Gaming Addict • Football fanatic #GGMU

1 comment

  1. like this zapier tips!

Leave a Reply