Mapping gmail contact label from sheets to a value in a cell

How To
1

Hi

When conencting to add a new contact on google contacts, i can see the labels that are already available in google contacts. Now when some one signs up with us, they let us know which area they are in (on a form that then goes to sheets)… which then corrosponds to a google contact label.

Is there a way to map the new google contact to attach it to a label that is in accordance to the cell in a google sheets?

2

Hi @Samer_Hakim and welcome to the Make Community!

I’m not quite clear on what you are trying to do. The labels you see in Make are the ones that exist in your Google Contacts. If you need new ones that don’t exist, you can simply create them in Google Contacts and Make will pick them up.

If you’re trying to decide which label to apply, there needs to be some logic somewhere in your flow that does that. It could be in Google Sheets, it could (maybe) be in Google Forms, and it could also be in Make prior to creating the contact.

L

3

Hi thanks for the response.
So the process is as follows:

  1. Connect to sheets to obtain data from new row including name and where they would like to work. They can choose Place A for example.
  2. Google contacts has some labels of places. EG Place A and Place B.
  3. After the connection is made from sheets- i create a new contact in google with all the details from sheets.

I can not however, ask contacts to attach a label “Place A” to the contact. That is not an option. I can select labels manually from the contacts manually from a tick box option, but not ask it to label the contact in accordance to the sheets.

4

Is the label in the sheet? If so, you can map the label from the sheet:

image

If the label is not in the sheet, you could send whatever information the user puts in the Google Sheet to AI with instructions for the AI to return the label. You can either fine-tune a model for that (it’s free to finetune on OpenAI until Sep 23) or create a prompt that works most of the time.

if none of that seems to make sense, I encourage you to share a screenshot of your scenario as well as the input and output bundles of running it. Someone might be able to spot the solution.

If you don’t want to share your real scenario, create a dummy one that exhibits the problem.

L

5

Hi and thank you.

I managed to get it to work by using the TOOLS “SWITCH” tool… where i select the input as the label that is on the form as the “apttern” and then “outputting” each of them to the required gmail labels format as “contactGroups/123googlelabel#id.”

To get that ID you need to click on the label in google contacts and read the address of the label.

It should work then.

3 Likes