How to send PIPEDRIVE data to a MYSQL database

[Fernanda_Silva]

Hello guys, im trying to get some data from PIPEDRIVE, making a workflow for every new update, like “Deals closed last week” example. how to choose the columns to be update with each data i got from pipedrive? the columns needs to be the same name as in the pipe drive?
This is what ive done so far:

[Fernanda_Silva]

to add: im mocking output data from the webhook based on a already functional workflow in integromat, but is so different from n8n i cant fully understant! thankyou

[whitbym]

Apologies for the deleted posts (just realised how to insert my workflow !)

I know it can be daunting starting with a new tool and examples are always a good way to understand.
I don’t know pipedrive but I do something similar e.g. with SendInBlue.
I already have a table created in the mysql database, which I truncate at the start of the flow.
Then I read in the SendInBlue data
Then I just insert the data into the table.

This is the create statement I used for the mysql database. I have read/write access to our database but you may have to ask someone if you don’t have access.

Good luck !

drop table if exists sendinblue_senders
;
CREATE TABLE sendinblue_senders
(
sender_id bigint unsigned
,sender_name text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
,sender_email text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
,sender_active boolean
,ip_addresses json
,PRIMARY KEY (sender_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

[whitbym]

My apologies, I’ve just realised that you try to update the data.
I don’t bother for the extracts that I do as the SendInBlue webservice results is always the latest version of the truth.

You could do something very similar as per @FelixL suggested ?:

Create a new row in my MYSQLTable when i add a new row to my GoogleSheet

Hi, im an intern in need i need to create a workflow where when added new data in the googlesheet it gets added to my table in my mysqldatabase. I got to add te first row, then when i added the second it says that the id is duplicated, because the first rows already existis in my table. How to add only the new ones and ignore existing data in the Sheet?

Compare the pipedrive data with the data from your existing data using the database select and then update the differences.

However, I checked the n8n documentation.

I can see there is a pipedrive update trigger

Pipedrive trigger | n8n Docs

You could perhaps use that as you will know that these are definitely records that have changed.
That way, you wouldn’t need to do any comparisons. Just update the records that have changed.

i.e. pipedrive trigger-> update mysql for changes.

A lot of the time it’s trial and error to see what works for you.

I followed all the n8n tutorials before trying to anything useful for the tasks I need to do:

Level one: Introduction | n8n Docs

Level two: Introduction | n8n Docs

Good luck

[Fernanda_Silva]

thank you so much, ill look into that now!