Upwork RSS feed, is there a way to use less ops?

[Kailtis]

Hello!

I’m new to make (started learning 2 weeks ago ).

Below is the screenshot of my scenario and also the blueprint.

What the scenario does is analyze periodically new job postings through chatgpt, and those who are validated are added to a sheet.

What I’d like to know is if there’s a way to use less ops. The last three modules (gpt, parse result, and google sheet) consume each one ops for every job posting. Is there a way to treat them “in bulk”?

I don’t even know if it’s possible, but figured I’d ask anyways.

Thanks!

upwork rss feed blueprint.json (58.5 KB)

[Mr.Make]

There is a way to optimize adding rows to google sheets. You can use an API call to batch Append (add) rows to google sheets so it takes up one operation instead of it taking up 100 if you have 100 job offerings. I will try to give you a hand through this.

1. Set up your data to aggregate in a text aggregator after you have all of the data you need from chat GPT so after the parse JSON. FYI I don’t think you can optimize further here and need to make one api call per your anaysis of job posting.

2. You want to structure the data in the text aggregator in a way that the google sheets api can read it. We can do that within the text module its self. Here you can see in one row we are adding three columns of data. rand, bundles and order. The format is below

[“column1data”, “columns2data”,“column3data”],

make sure you keep all the and , so the api can read it and make sure your row separator is set to new row. You can add more columns of data if needed following that format.

the output will look like this
.

Then all you want to do is use make an api call and set it like this. Set your text aggregator variable where text is.

URL: spreadsheets/REPLACEWITHYOURGOOGLESHEETID/values/REPLACEWITHSHEETNAME!A:Z:append
qs:
key: valueInputOption
value: USER_ENTERED

body:
{
“range”: “Sheet1!A:Z”,
“majorDimension”: “ROWS”,
“values”: [
textvariable
]
}

See it in action below:
Would normally take 11 operations to get all data from airtable and push to google sheets took 3 operations

10 bundles from airtable:

data aggregated:

Added to google sheets:

Let me know if this helps you! Pretty complex API call. This would be really good to learn if you just started using MAKE. Unlocks a new superpower!!! The api call @Kailtis

[Kailtis]

Thank you very much @Mr.Make ! At least I know there’s a solution

I read through your reply but I’ll be honest, I didn’t understand all the steps
I’ll go back through it tomorrow with a fresh mind, and if I can’t figure it out I’ll let you know.

Also, is this method valid if I want to keep adding new rows to the sheet as new job postings come in?

Thanks again!

[Mr.Make]

Yes this is for adding new rows every time you run your scenario. It will only use one operation to add all rows.

If you need more help I am here .

[Kailtis]

Okay, I’m pretty sure I must have not correctly understood what to do exactly on the api call.

The error:

Here’s the screenshots of what I did :

• Api call 1:
  

  

• Api call 2:
  

  

• Text aggregator:
  

  

[Mr.Make]

Hi @Kailtis you forgot to add the Query String in. Let me know if this solves it!

[Kailtis]

Not exactly sure what to put in there,
Can you be more specific?

Here’s what I tried :

Which gives me this error:

Thanks in advance

[Mr.Make]

That’s ok always good to learn.

Here is my entire request just follow this along.

[Kailtis]

Thanks but I can’t figure it out.
I’ll just keep learning and come back to it once I’m more experienced, thank you for your help!

[Mr.Make]

Of course good luck!!

Try going through the MAKE courses.