Match userid (cellphone) with unique cellphone reference in google sheets

(Alicia) #1

I am storing information about the user in google sheets - when the person texts in, I would like to store that information as attributes (firstname, address, age, etc).

For some reason, I can’t get flow xo to match the numbers. I tried including a + at the beginning, but that did not work. I tried without the plus, also did not work.

I am using the google sheets integration -

then search rows

match cellphone with userid from flowxo (also tried to set an attribute and match on that)

then i take the matching results and store as attribute.

Help please!

(Kellsey Shaw) #2

Hi Alicia,

What messaging platform are you using? And what do you see in your logs for the Google Sheets Search task; Where there any results provided or did you get an error?

Regards

Kellsey

(Alicia) #3

Hi! It says that the column title might not be supported. I think that I resolved the issue through trial and error.

The way I handled it:

  1. Stored the cell number as an attribute
  2. Added 10
  3. Subtracted 10

This was to remove the “+” so that it would match with the google sheet.

Is there a more direct way to accomplish this?

Thanks,
Alicia

(Kellsey Shaw) #4

Hi Alicia,

Can you share your sheet (we only need the columns) so that we can see what it is that you are working with? You can send this to support@flowxo.com to keep it private.

We’ll then be able to take a look and see the best way to go about it