I need an app that automatically sends photos dropped in a Google Drive folder to Pinterest native scheduler, to be posted 30 min later on my board.
To avoid the photos being posted “empty”, I would like the system to retrieve the title, description, link and hashtags of the pin from a google sheet prepared in advance.
It should also check the number of pins already scheduled for a day, and remember them. If there are already 30, post the photos the following day and so on. Finally, the program should then move the scheduled images to a Google drive subfolder named “Scheduled”.
Any help would be a great time-saver, many thanks in advance !
Hello! I can help you create a workflow in Pipedream that accomplishes your requirements. First, let’s break down the steps:
Trigger the workflow when a new photo is added to a specific Google Drive folder.
Retrieve the title, description, link, and hashtags from a Google Sheet.
Check the number of pins already scheduled for the day.
Schedule the pin on Pinterest with a 30-minute delay.
Move the scheduled image to a “Scheduled” subfolder in Google Drive.
To start, you’ll need to use the Google Drive - New File trigger. Follow the instructions in the trigger configuration screen to set up the trigger for the specific folder you want to monitor.
Next, you’ll need to use the Google Sheets - Get Row action to retrieve the title, description, link, and hashtags from your prepared Google Sheet. Make sure to connect your Google account and configure the action with the correct Sheet ID and row number.
To check the number of pins already scheduled for the day, you can use the Pinterest - Get Pins action and filter the results based on the scheduled date.
For scheduling the pin on Pinterest with a 30-minute delay, you can use the Pinterest - Create a Pin action. Connect your Pinterest account and configure the action with the Board ID, Title, Media, and other required fields.
Finally, to move the scheduled image to a “Scheduled” subfolder in Google Drive, use the Google Drive - Move File action. Configure the action with the File ID and the ID of the “Scheduled” subfolder.
Please note that you might need to use custom code steps in your workflow to process and filter the data as needed. If you need help with any specific step, please let me know!
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.