Video Post

Download videos from tiktok and post in:

facebook page
youtube shorts
instagram reels
twitter
tiktok

Project type: client

Table of Contents

Build With
Media
Details
Install
Settings
Run

Build with

Details

Workflow

Checks if the current time and date match the publication date configured in the google sheet.
Validate the videos in downloads folder with the name or download it from tiktok.
Validate the duration of the video for each social network, and made the necessaries file conversions.

Note: each social network have different limits of duration for the videos. If a video is longer than the page limits, it is automatically skipped.

facebook: 240 minutes
youtube shorts: 60 seconds
instagram reels: 60 seconds
tiktok: 60 seconds
twitter: 2:20 minutes

Additional, for upload the videos to twitter, they require and extra conversion with the page: https://servicios-web.online-convert.com/es/convertir-para-twitter (This step is done automatically)

Post the video in each social network type the tilte, description and tags/keywords.
Move the video to done folder.

After post all videos, the google sheet is updated.

Warnings

Youtube

By default, youtube have a limit of 15 uploads per day. You can upload more videos with a manually verification. If you try to upload more videos without the verification, the program will raise an error.

Instagram

For upload reels to instagram, we use the extension INSSIST. At this time, the extension have a bug that allow us to post reels without limits, but when the developers fix it, you will need to pay for the extension to continue using the reels (at the moment, there are no other alternatives).

Google chrome

While the program is running, you will not be able to use your Google Chrome browser Also, make sure that when you start chrome, it opens a new blank tab (not the last open tabs), to avoid errors.

Files

The program automatically replaces the files in the "done" and "downloads" folders. Make sure you don't have any important videos with the same names as the spreadsheet, or you will lose it

Updates

This is a web automation project. Web automation depends entirely on the structure of the page, which means that if any social network is updated (for example, facebook) and changes the way videos are uploaded (a structural change (html) with or without changes layout (css)), the project will need to be updated too.

Install

Install all modules from pip:

$ pip install -r requirements.txt

Settings

Programs

To run the project, the following programs must be installed::

Google Chrome last version

Generate Google API Key

You can learn how to generate an API Key for google sheets, in this tutorial

Create spreadsheet

You need to create a spreadsheet in the same google account that generated your API Key.

The name of the spreadsheet does not matter, but it is recommended to use "video post" or something similar, to easily identify it

Columns

The names of the columns are the following:

Note: all letters must be in lowercase and without spaces or extra characters

date time
file or name
title
description
tags
processed
uploaded instagram
uploaded facebook
uploaded twitter
uploaded youtube
uploaded tiktok

Note: more detail about the google sheet in How to use > Google sheet section

Setup chrome

This project does not require users and passwords to login, instead it will use the sessions that you already have opened in your browser.

Before running the project, you need to do some extra steeps for prepare your google chrome.

Login to your instagram account.
Login to a facebook account how have access for post in the facebook page.
Login to yout twitter account.
Login to your youtube account.
Install the following extensions in chrome: AdBlock y Insist

Config file

All configurations are saved in a config.json file, so you can create and edit it manually

This is the content of the file (copy, paste, and replace with your datz):

{
 "chrome_folder": "C:\Users\{your user name}\AppData\Local\Google\Chrome\User Data",
 "facebook_page": "https://www.facebook.com/your_page_name/?ref=pages_you_manage",
 "api_key": "{project folder}\video post\sheets-340407-d8642222c103.json",
 "sheet_url": "https://docs.google.com/spreadsheets/d/1Eh1...iw0M/edit?usp=sharing",
 "instagram": false,
 "facebook": false,
 "twitter": true,
 "youtube": false,
 "tiktok": false

}

chrome_folder

The path of google chrome data. By default, in windows, there it in: C:\Users{your user name}\AppData\Local\Google\Chrome\User Data

api_key

Path of your google api key in json format, generated in Install > Generate Google API Key section

sheet_url

Link of the google sheet with edit permissions. Here a tutorial about how to generate the link

facebook_page

Link of your facebook page.

instagram

Post (true) or skip (false) all the videos for instagram

facebook

Post (true) or skip (false) all the videos for facebook

twitter

Post (true) or skip (false) all the videos for twitter

youtube

Post (true) or skip (false) all the videos for youtube

tiktok