Ideas to reduce operations in the following scenario

How To
1

Hi all,
i am using make.com to send our leads captured in Salesforce to Clickup.com.
It sounds kind of straight forward and it actually could be, but before i started in my company, Clickup fields were set up as dropdowns, which means they got all unique IDs. Therefore i first have to always match the ID with a Google Sheet in between, which for like 10 dropdown fields costs kind of many operations. Thinking of 30 leads per day, across 3 different products, we are always maxing out our operations. Is there a way how we can reduce the amount of operations needed?

image
image1705×232 53.9 KB

Right now (as a example for the country), i

  • get from Salesforce the country
  • have to search this county in Google Sheets and take its ID
  • us this ID to set the correct dropdown option in Clickup.

Can i maybe use a data store as a solution? All the Google Sheets search rows modules in the screenshot are just to take IDs which take too many operations

Best regards
Daniel

2

Hey there,

we will need a lot more specifics on what each module does to see what can be cut down.

For example → ClickUp dropdowns also accept orderindex, not just ID. This will make typing the formulas a lot easier. Also the formulas can go directly inside the ClickUp module, so you don’t need the Tools module to transform it first. If this is what you are using all of those Tools modules, you can start with deleting them and moving the formulas directly in the next modules.

3

Hi Stoyan, nice to hear from you.
Basically all green modules are search rows Google Sheets modules. Each one will get a different ID for a needed field, like ID for country, Owner, UTM Medium, etc - but the way it works is always the same:

I give Google Sheets the info from Salesforce, it searches the info in Google Sheets and if found it returns me the ID for the input value, country, for example. All these returned IDs i save as multiple variables and these are then inserted in the Clickup module as the value.
Theorectically i can skip the variables step, i know, but still the search and match option with Google Sheets takes much ops, so im looking mainly for a way to skip specifically this one.
Ill have a look tho into orderindex, thanks!

4

And how is the sheet structured? Cant yo execute one search to get all of the variables you need?