Semi-automate multiple videos from 1 blog - Canva Bulk Upload

Learn how to automatically turn 1 blog post into video scripts using Zapier, Google Docs and ChatGPT. And how to bulk upload this to Canva and create multiple short-videos at a time.
My Ai & automation services: www.theaborch....
The video shows a python script to be used to convert the table from Chat GPT to a Google sheet. Here it is:
"import csv
from io import StringIO
def parse_table(table_str):
lines = table_str.strip().split('
')
Remove the separator line
lines = [line for line in lines if not line.startswith('|--')]
reader = csv.reader(StringIO('
'.join(lines)), delimiter='|')
headers = next(reader)[1:-1] # Skip first and last empty cells
headers = [h.strip() for h in headers]
data = []
for row in reader:
if row: # Skip empty rows
row_data = [cell.strip().strip('"') for cell in row[1:-1]] # Skip first and last empty cells
data.append(dict(zip(headers, row_data)))
return data
If the input is a file path (for text document), read it first
input_data = input_data['ai_output']
if input_data.endswith('.txt'):
with open(input_data, 'r') as file:
input_data = file.read()
output = parse_table(input_data)
return {'output': output}"
How to Instruct ChatGPT to Create a Table for Automatic Video Script Generation:
To use the Python script shown in this video, you need to give ChatGPT specific instructions to create a compatible table. Here's what to tell ChatGPT:
"Create a table with 4 columns: Title, Slide1, Slide2, and Slide3. Follow these rules exactly:
1. Start with a header row: | Title | Slide1 | Slide2 | Slide3 |
2. Add a separator row: |-------|--------|--------|--------|
3. For each data row, start and end with | and separate columns with |
4. Ensure there's a space after each | at the start of a cell, and before each | at the end of a cell
5. Don't use any quotation marks in the cells
6. Provide at least 3 data rows (not counting the header and separator)
7. The content should be about turning a blog post into video scripts
Here's an example of the format:
| Title | Slide1 | Slide2 | Slide3 |
|-------|--------|--------|--------|
| Row 1 Title | Row 1 Slide1 content | Row 1 Slide2 content | Row 1 Slide3 content |
| Row 2 Title | Row 2 Slide1 content | Row 2 Slide2 content | Row 2 Slide3 content |
Please generate the table content now, following this format and these rules exactly."
This instruction will make ChatGPT create a table that works with the Python script demonstrated in the video. Remember, the script is designed to handle this specific table structure, so following these instructions is crucial for the automation to work correctly.
If you need help modifying the Python script or creating more advanced instructions for ChatGPT, consider using an AI assistant like Claude, which can provide tailored coding and prompting advice.
For more details on the entire process, including how to use Zapier, Google Docs, and Canva for bulk video creation, please watch the full tutorial above!