Using Google Sheets to automate Social Media Content

[Deven_Rudder]

Hello,

I am extremely new to Make and am looking to create social media content with Google Sheets.

What I’m looking for is pretty similar to the solution found in this link, but didn’t really work for me.

Multi-platform Social Media posting

Recently signed up and decided to try out Make. I’m trying to build an auto-scheduler for multiple social media accounts pulling from Google Sheets. Specifically, a random row is selected from GS then ran through a router chucking data between 3-5 social media accounts. My issue is when Google Sheets reaches the end of the current list, it only watching for newly created rows. How can I get Make to randomly select rows that are already in the list regardless if there is a new row or not?

I have a Google Sheet with 3 Columns - Date, Etsy Listing URL, and Image URL. What I want it to do is this:

As long as the date field is empty, I want it to select a random row. Once the row is selected, I want it to pull the Google Drive link found in the Image URL column and have Chat GPT analyze the image and give me a description for social media content. Then I want it to use the image and the generated desceiption to create a post for my all of my social media platforms.

I got close with Google Sheets > Array > ChatGPT (Visual Analyzer). But then I was running into issues with “Image Not Found” despite using the correct Google Drive image link with the Doc ID instead of the shared link.

Any advice would be appreciated.

[samliew]

Welcome to the Make community!

Please provide the following:

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at. You can upload images here using the Upload icon in the text editor.

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. And most importantly, Input/Output bundles

Please provide the input and output bundles of the modules by running the scenario (or get from the scenario History tab)
then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

Join the Make Fans Discord server to chat with other makers!

[Deven_Rudder]

Overall:

Please note, I’m only in the testing phase right now to see if the backend stuff will work before I route to the social media pages.

Google Sheet:

Google Sheets: Search Rows:

Array Aggregator:

Tools: Set Variable:
Variable Code:

Error:

OpenAI: Analyze Image:

This OCCASIONALLY receives an error because no value was detected from the Tools > Variable code. It didn’t select a row, therefor the OpenAI visualizer couldn’t work. However, I know it does work because sometimes the “random row selector” does select a row and allows the next step to proceed.

So, I have a two part problem.

The biggest issue is that sometimes it doesn’t select a row…at all. And causes the next steps to fail.

The second issue is that when it DOES work, it goes straight down the list and doesn’t select a random row.

BluePrint:
blueprint.json (41.6 KB)