Duplicate row in Google Sheets

[Felipe_Falasca]

What are you trying to achieve?

Hi, I think what I’m looking for is a really simple process, but I’m new, so please be gentle.

I currently have an Apollo.io automation that is triggered when a contact is updated in the platform (status change). Once the process is complete, it adds all the data for this lead to Google Sheets.

However, when running the automation, it repeats the data from the first leads that were updated and adds the new ones.

Is there a way to say “If the column already has the lead’s name (column A) don’t add it. If it’s a new name, add it next so we don’t have duplicates in the spreadsheet?”

Again, please realize that this is a very simple solution and that I’m probably working backwards to achieve it, I’m just not up to speed with all the tools yet.

Thanks in advance

Screenshots: scenario setup, module configuration, errors

[L_Duperval]

Where are the leads taken from? Is Apollo only adding new leads or could it be duplicating the leads?

Are all of the sheets in your flow the same one? Or are you working with 3 different sheets?

It would be important to know what each of those sheets modules is doing. It’s possible that in your Search Rows you’re always taking the existing rows and adding them to the last sheet, which might explain the duplication.

What are the input and output bundles of the Google Sheets modules?

L

[Felipe_Falasca]

All leads are saved by Apollo. It is also possible to exchange or “status” of each lead individually. Hair testifies that it always repeats itself based on and adds the new lead as the updated status.

When automation is activated, leads with the status “interested” are added to Google Sheets.

Here is an example of what happens:
Jose - interested
João - cold
If I change João’s status, a new information included in table:
José - interested
João - interested
José - interested

Apollo does not have an intelligence to trace just the new leads as o updated status.

Please, disregard this scenario, because I tested modules.

Do not understand this section - What are the entry and exit packages of the Google Plan modules?

I’m sorry, but I’m new in Make.com

[L_Duperval]

Hi @Felipe_Falasca and welcome to the Make Community! (that should have been in my first message…)

Input and output bundles are what each module produces when they are run. They appera as bublles with numbers in them and look like this:

I encourage you to take a look at the Make Academy to get a better feel of what Make is all about:

https://academy.make.com/collections/make-foundation

That said…

You can get the input and output bundles by running your scenario, clicking on the number in the bubble (which represents the number of operations consumed) then clicking on “download input/output bundle”.

Then you can either take a screenshot of the result or and share it here or, if the data is too large to fin in a screenshot, copy and paste it here betweet code fences

Like this, so you keep the proper formatting

[
    {
        "success": "true"
    }
]

L

[Felipe_Falasca]

Hi, thank a lot for your support.
I will take a look at the Make Academy! I need to learn about.

Here the screenshots:

1. First run
   

   

2. The result in Google Sheets
   

   

3. Then, I update the status in Apollo (Felipe) to “interested”
   

   

4. The final result in Google Sheets. Duplicate the first names that are already in the “interested” status
   

   

Now, the datas of result (add a row)