Creating automatic blog content from google sheet to chat gpt to wordpress

Hello there!
First time using make and I have been in down a rabbit hole with this setup with so many system changes none of the tutorials I have watched and read (my eyeballs and head hurt) do not match what’s currently working and then sets me back to square one and I am pulling my hair out.

I figured out most of the automation pieces but the Google Sheet connection. I watched the tutorial on a workaround from using the google sheet addnon (RIP?) to doing it through the Apps Script and I believe I did the steps but the video shows a scenario with two Google Sheets, one is “perform a function” and the other one is Watch Changes, they are not connected.

My challenge is that I add the first Google Sheet connection “perform a function” I get the URL for the webhook…cool
Then when I try to add the Google Sheet connection “watch changes” (or any of the instant options) show up.
Here is the video tutorial I am following:

When I do the “watch changes” first it works but then when I add the next google sheet “perform a function” does not show up as an option.
I am assuming that something changed in how this is supposed to work and a tutorial has not been done yet…this is what Ive been experiencing several times through this project. I am not a programmer or coding so this is extremely hard for me to understand but I am pretty good at following instructions so here I am.

Please send help…or Tito’s vodka :joy:

1 Like

Hi @Yamil_Francisco,

You’re not seeing perform a function because my guess is you’re probably looking at a dropdown of “action” steps. In the loom video they demonstrated two example of how to initiate a Make scenario, basically two examples of Step 1. They did not demo any “action” steps which are steps that occur after a trigger. Do you still need help?

Not sure what you mean. So did the video showed 2 different examples of step 1? So I can use one of the other? Because if you watch the video that does not seem to be what they did.

To get both trigger actions available like it appears in the video then. Away from your first Google Sheet Module, right click the screen and click add module (Pictured).

You should then be able to select “Perform a function”. The key here is that there shouldn’t be a line connecting the two. You can then change the runtime by dragging the thunderbolt icon between the two.

-@Trainward_Consulting

It’s ok, doing that wouldn’t work either way. I just figured out another way to do what I needed much simpler. Thanks for responding.

1 Like

Of course, I’m glad you figured it out!

Hello @Yamil_Francisco :waving_hand:

Would you have a minute to share your solution? It could help other Makers in need. :hugs:

Thank you!

1 Like

My solution was to stop trying to make it work and instead of “watching” the google sheet I am just adding to it when a new record/post is made. Using the webhook stuff is not beginner friendly.

3 Likes