Google Drive Blog Automation

How To
,
1

Hey Makers,
I am working on an automation to post blogs on wordpress using Google Drive inputs. The keywords and topics corresponding are uploaded on the Google Drive using Watch New Rows. The array aggregator and set a variable is supposed to calls for the topic randomly and post. However, it always picks up the first keyword and same topic everytime it generates content. All the other functions of the workflow are in the order except for randomly choosing the keyword & topic for generating content. Thank you for your help in advance!

image
image501Ă—749 21.5 KB

3

Welcome to the Make community!

Looks like you are using “Search Rows” module, which might always return the same search results every time the scenario is run.

Did you mean to use the “Watch New Rows” trigger module instead?

2 Likes
4

Thank you for a quick response. I tried to use “Watch New Rows” too and the output was same. Here’s the screenshot

image
image821Ă—643 22.9 KB

5

Go to the Epoch Panel, by right-clicking on the trigger module (polling triggers only), and select “Choose where to start” from the list of options in the context menu.

If you select “From now on”, the next time the scenario runs it will only return new data (or nothing if there is no new data).

For more information, see

3 Likes
6

I tried, but it gives only 3 options - Specific ID, All, Choose Manually. The option from now on is somewhat not visible. Which of the above 3 would work?

image
image1256Ă—379 49.1 KB

7

Hmm, then you might have to run through all the existing rows until it reaches the latest item.

This might possibly be a bug?

For quicker assistance with technical issues like these, you may want to contact support directly. They respond very quickly and update you frequently on the status of their investigation.

2 Likes
8

I am in touch with support from multiple days, but there’s not been much resolution. Hence, reached out to the community. Running through all the rows might not be a feasible solution as it contains over 125 rows.

Any of the 3 ID, All, Choose manually won’t work?

9

Is it supposed to integrate with Google Drive/Google Sheet? Unfortunately, I am running pillar to post for the issue. Can you suggest what can be done to activate topic randomiser using GOogle sheet integration?

10

You can try creating a brand new sheet to watch.

Sometimes, the “Watch New Rows” module won’t work properly after you delete any column or row in the sheet.

2 Likes
13

Hello @SocialScion

I noticed that you’ve opened a ticket with us, and our support team has investigated the matter and provided you with the following advice :arrow_down:

Extra context:
I’m looking at two columns keywords and topics both which should be uniquely picked up. If I use watch rows the next step for setting variable doesn’t work. Could you guide if I want the automation to write a different keyword and topic everytime it runs, which is the best way?

Make Support response:
You may have to use “Search Rows” as trigger. If you prefer repetition of records not to take place, please have a separate column to track which row has already been processed, and to add value to this column you may try “Update a Cell” module, a filter can be placed right after the “Search Rows” trigger to exclude this row if system fetches it again. More information on filtering: https://www.make.com/en/help/scenarios/filtering

2 Likes