Hi there, Woxian! 😎Here you'll learn how to create videos for Calendar Ideas in a Google Spreadsheet. How cool is that?
If you already met our newest feature Calendar Ideas, you'll know that you can organize your videos by date. Later on, it will be much easier to schedule your videos on your social media. Either with WOXO's integrations or from your favorite scheduling tool. If you haven't tried Calendar Ideas, click here to learn more but now, let's start right away!
Once in the Template Page, activate Calendar Ideas and start by selecting the video topics you want in your Calendar Ideas. To remove any topic just unselect by clicking at the top right corner.
Now, select all the videos shown in the Calendar view by ticking next to the month,
Or tick 1-by-1 on the colored circle in the corner of each video. You can edit the date later!
Once selected your favorite video templates, look at the bar below and click on "New Project" to go to the Edit Videos Page.
Once you're here, we will use the data shown in the spreadsheet-like table and customize videos directly on Google Sheets.
To do that, you can (1) either copy the content of the table and paste it in a new Google Sheet - to start customizing right away:
Or (2) download the current .csv file, by clicking on the Integrations button:
Next, upload the .csv you just exported to your Google Drive and open it with Google Sheets. In case you copied the table, paste the content in a new Google Sheet.
The video template will look like this:
Now you can start to customize your videos as you wish. If you need a refresher on how to edit videos from spreadsheets, we got you! Just click here.
Now, let's move on to the fun part! At the right of the table, you'll see a new column called Date. Here is where you'll customize the time and date of each video.
To set a date and time, just edit the data in the cell shown above. Be cautious to leave one space between each element. The formula is the following:
Day of the Week + Month + #Date + #Year + #Hour + Time Zone
For example, if you want a video to be scheduled for the 2nd of August, 2021 at 2 pm. The formula you'll need to type is the following: Mon Aug 02, 2021, 14:00:00 GMT-0500 (Colombia Standard Time)
Here's an additional tip: you can leave the time zone unchanged. Once you export, your time zone will be set automatically.
Once you've set up the date and time for all your videos, just copy the spreadsheet's URL right until the /edit.
Now, let's go back to WOXO Video Maker. Click on the Integrations button and hit on "Import GoogleSheet". Now paste the URL you previously copied and last but not least, click on "Pull".
Make sure the sheet was successfully pulled and there are no videos with errors. If everything looks okay, click on "Import Videos". Your videos will be displayed on the Edit Video Page immediately!
Continue to the Export Page to download or share your videos.
Remember that with Calendar Ideas format, your videos will be downloaded with the designated date and time as their filename.
And that's it: CONGRATULATIONS! 🥳 You're ready to customize your videos as you wish and schedule them to take your marketing game to the next level 🚀
If you've got any questions 一 really, any 一 don't be shy and just give a call out at our Support Chat or contact us at [email protected], we'll be more than happy to help you!