Hi everyone, sometimes I get this error (500) and other times it doesn’t come out, to solve the problem I can insert a sleep tools between GET GOOGLE DRIVE ID and UPLOAD IMAGE/VIDEO TO BLOTATO
You can implement a Sleep Module (60 seconds) before the next upload and avoid duplicate URLs (Add Status Column) will solve that issue.
1 Like
Hi, so the sleep is 80 seconds and I don’t understand what you mean with (Add Status Column) this is a bug, because it happens that the link is lost for each video.
Google Sheets Module (Search Rows)
Create a column (Status)
Status is empty or does not exist (Filter)
This implements a system that’ll pick the rows which are not yet uploaded or posted.
Here’s how I envision your flow:
Search Rows > Get Google Drive Data > Activate Sleep > Upload Google Drive Data to Blotato > Router
Route 1: Create TikTok Post
Route 2: Create YouTube Post
Route 3: Create Instagram Post
Update Rows > Update Status
Let me know how it goes!
I have this excel file with the “State” column that reads “ready”, after taking the uploaded link it puts the green flag, the green check
Now, you just need to use it to filter each row is uploaded exactly once, this prevents duplicate or simultaneous uploads that is causing the 500 error in Blotato. The goal is to perform one upload at a time or avoid uploading in a short timeframe.
I’m still getting this 500 error. There are no duplicates because the automation is getting a different link for each row. Why isn’t anything working today?
Hey Christian! So, I am not sure how long videos take to upload, but 80 seconds might not be enough. The issue is that 80 seconds is a deterministic metric for a variable metric (upload video time) so you might have to either increase the sleep timer, or maybe create a subscenario that you can call that ONLY uploads videos and see if that works. But as far as I am seeing Blotato does that in a queue/sequentially and not in parallel (?)