How can i create/update new contact to keap from google sheet and add tag to contact

[vukhcsoncoin]

Hi there,

How can i add tag to contact which is created / update to keap from google sheet.
I have tried setting like the image bellow

and when i hit "save and send test request", this is what i got

I think it did not work, so can you help me how to set up the right way!

And i see that, if i buy 1 year package, 10.000 acction/month, what does it mean? when one contact is created from google sheet to keap and add tag, it is counted one, or anythings else, when i using make, i just use two step, google sheet => create contact to Go Highlevel, it is just about 700 contacts were created in GHL but it take 10.000 operation in Make.com

Thanks

Trả lờiChuyển tiếp Thêm lượt thể hiện cảm xúc

 

[vukhcsoncoin]

And i see that, if i fill colume by colume in google sheet, then it work, but if data in google sheet is from form in landingpage, or if i paste a row to google sheet, that mean, all infomation are fill at one time, it does not work, what should i do

 

[Preeti Paryani]

Hello @vukhcsoncoin,

Please provide us with the workflow URL where you're facing this issue so we can better look into the issue and assist you further.

 

[vukhcsoncoin]

Hello @vukhcsoncoin,

Please provide us with the workflow URL where you're facing this issue so we can better look into the issue and assist you further.

https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZlMDYzMTA0MzI1MjZhNTUzNjUxMzQi_pc here is it

 

[vukhcsoncoin]

Hello @vukhcsoncoin,

Please provide us with the workflow URL where you're facing this issue so we can better look into the issue and assist you further.

I use a landingpape in my own to collect data, then, it will be send to google sheet. And now, what i want is when new row is added, contacts will be added or updated in keap, and allso be added tag. But when i add a test contact collume by colume in google sheet, it work, contact was created or updated in keap immediately, but if i fill form in ladingpage, then new contact is added in google sheet, but nothing happen in keap, i can not see new contact is added here!

 

[Preeti Paryani]

Hello @vukhcsoncoin,

And i see that, if i fill colume by colume in google sheet, then it work, but if data in google sheet is from form in landingpage, or if i paste a row to google sheet, that mean, all infomation are fill at one time, it does not work, what should i do

When entering the data into your Google Sheets, make sure to add the data to your trigger column as well in order to trigger the workflow.

To make automation work, you need to enable 'Send On Event' if you're manually entering data into your Google Sheets. If the data added to your Google Sheets comes from another API or third-party application, you also need to enable 'Auto Send on Schedule'.

Note: If your data is being added from an external source/API, your workflow will take up to 1 hour to get triggered.

How can i add tag to contact which is created / update to keap from google sheet.

It looks like you have successfully added the tag to the contact—please refer to the attached image for confirmation.

However, if you want to add dynamic tags, you can use the Search Tag option to find the tag by its name. You can also map the tag name from the data received in the trigger, provided it is being fetched correctly.

And i see that, if i buy 1 year package, 10.000 acction/month, what does it mean? when one contact is created from google sheet to keap and add tag, it is counted one, or anythings else, when i using make, i just use two step, google sheet => create contact to Go Highlevel, it is just about 700 contacts were created in GHL but it take 10.000 operation in Make.com

Any action performed within your workflow is considered a task. However, triggers are not counted toward your task usage—only action steps are included. Additionally, internal tasks such as Filter, Router, and Formatter in Pabbly Connect do not count as tasks.

For example, your current setup consists of three steps: one trigger and two action steps. To process 700 contacts from Google Sheets, where each contact undergoes two actions (creating the contact and adding tags), the total task consumption will be 1,400 tasks (700 × 2).

Let us know if you have any further questions.

 

[vukhcsoncoin]

So, which my setup above, which 10.000/month, it can be sent 5000 contact from google sheet to keap, im i right?

 

[Preeti Paryani]

Hello @vukhcsoncoin,

Yes you're right.

 

[vukhcsoncoin]

Hello @vukhcsoncoin,

Yes you're right.

And you said about pick Collume to trigger automation, im so cunfuse about this thing, what happen if in my colume have 5 information collume, A: date, B: Name, C: Phone, D: Email, E: Note. Sometime, i collect full information include E collume, note, but sometime, just A,B,C,D. So i should chose D im i right?, and can i map E collume to keap in this case

 

[Preeti Paryani]

Hello @vukhcsoncoin,

You can only select one column as the trigger column in your setup.

• If you choose Column D (Email) as the trigger column, only data up to Column D (A, B, C, and D) will be sent to Pabbly Connect. Column E (Note) will not be included, and you won't be able to map it further.
• If you select Column E (Note) as the trigger column, the workflow will not trigger until data is entered in Column E. This means that unless you fill in the Note column, the data will not be forwarded to Pabbly Connect.

Let us know if you need further clarification.

 

[vukhcsoncoin]

Hello @vukhcsoncoin,

You can only select one column as the trigger column in your setup.

• If you choose Column D (Email) as the trigger column, only data up to Column D (A, B, C, and D) will be sent to Pabbly Connect. Column E (Note) will not be included, and you won't be able to map it further.
• If you select Column E (Note) as the trigger column, the workflow will not trigger until data is entered in Column E. This means that unless you fill in the Note column, the data will not be forwarded to Pabbly Connect.

Let us know if you need further clarification.

How about if i pick D, but missing information in A, or B, C, D

 

[Preeti Paryani]

Hello @vukhcsoncoin,

If you select a specific column as your trigger column, the workflow will trigger even if all other columns are empty, as long as data is entered in the trigger column.

However, if you add data to all columns except the trigger column, the workflow will not be triggered.

In your case:

• If Columns A, B, and C are left empty, but Column D has data, the workflow will trigger.
• If Columns A, B, and C have data, but Column D is empty, or if all columns are left blank, the workflow will not trigger.

To learn more about setting up the Google Sheets "New or Updated Row" trigger, please refer to this step-by-step tutorial -

.