Google Sheets Company Contacts -> to Bigin Zoho

Questions
, ,
1

What are you trying to achieve?

My goal is to maintain a continuous CSV-style list in Google Sheets, where I can keep adding new rows or occasionally insert new columns. After that, I want the list to automatically synchronize with Bigin on a regular basis — updating existing business contacts and creating new ones if they don’t already exist. Assigning a “Partner ID” to each contact in advance within the sheet would not be a problem for me.

I created a Google Spreadsheet with company contacts.

The bot helped me connect both systems, but when I run the scenario, I get duplicates depending on where the company name is listed in the sheet.

For example, “Food SA” in column B8 ends up being created 7 times (minus 1 for the column header “Company Name”). Obviously, this makes no sense.

I asked the bot to adjust the scenario. It now looks the way I want it to, but it still doesn’t work.

This is the error I get: “The operation failed with an error. Validation failed for 1 parameter(s).”

I also have to admit that I don’t really understand what exactly I should select: Builder or Custom, and I’m not sure what else I should have chosen at the bottom.

Steps taken so far

I tried several different combinations, but as I mentioned above, I’m not sure where the actual problem lies or how to fix it.

Thanks that you took the time to read this.

Screenshots: scenario setup, module configuration, errors

1.png
1.png395×259 13.8 KB

3.png
3.png483×355 25.6 KB

4.png
4.png452×577 23.2 KB

2.png
2.png1220×640 50.1 KB

3

Welcome to the Make community!

That’s probably because you might need to select at least one field to return. If you are unsure, try selecting “Select All” fields.

On a related tangent to your question,

Practically, if you are only expecting a single result from a “Search” module, as a “best practice” you should set the Limit to 1.

Otherwise, if you are expecting a list of results from each search module (you have more than one)— you need to aggregate the results of that module.

Hope you get it sorted. Don’t hesitate to respond if you require more help.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!