your dashboard. You can find your keys by clicking on API Keys in the top right corner of the dashboard. Make sure to use your stage key for testing purposes as this key isn’t charged. Once you are happy with your workflow you can switch over to your production key.
Add the Google Sheets and Shotstack module and connect them as follows:
The Google Sheets module searches for the current day of the month and send through that data to the Shotstack module.
Shotstack renders your video in a similar manner to how you would use a desktop editing solution. In your timeline you add the different tracks and clips that make up your edit. In this particular example we use three tracks:
In the overall configuration of the Shotstack module we choose our output format as MP4
and set our output resolution at HD
. We will also fill in the callback URL with the webhook URL we get when setting up our next scenario.
You can learn more about how Shotstack works in this quick start guide.
Add the Shotstack Watch module and connect them together. The Watch module waits for a video to finish rendering, it then searches for the video in Google Sheets, and finally the video URL is added to the appropriate row:
Turn on the watch scenario to start listening for completed renders and run your render scenario to see your workflow in action. Now schedule your render scenario to run daily and your workflow will create a new personalised video every single day.
curl --request POST 'https://api.shotstack.io/v1/render' \
--header 'x-api-key: YOUR_API_KEY' \
--data-raw '{
"timeline": {
"tracks": [
{
"clips": [
{
"asset": {
"type": "video",
"src": "https://shotstack-assets.s3.amazonaws.com/footage/beach-overhead.mp4"
},
"start": 0,
"length": "auto"
}
]
}
]
},
"output": {
"format": "mp4",
"size": {
"width": 1280,
"height": 720
}
}
}'