This post was split from the topic: Can I duplicate my facebook lead ads if I already send them to Hubspot and then I create a zap (this time sending the facebook lead id)
I already tried several combinations but I still haven't solved it. I did 2 zaps. The pimeo goes from facebook to google sheets, there I leave the data I need from facebook, the lead id. My second zap is more complex: a contact is created in hubspot and I send that data to the same spreadsheet where I sent the facebook data, there I only send the hubspot record id. All the information is in its respective column to avoid overwriting. I did it that way but the information was wrong. For example, column A2, B2, C2 and D2 received the data of: lead id, email, telephone, name and date of creation. from A to D they err data from facebook. then I have my column E, there the hubspot id record arrives but it arrives at I3. So when updating the contact in hubspot (next zap step) hubspot takes the number 3 as the lead ID, as the information is not aligned, the data does not match.
save try to put a formula to my google sheets. I send the hubspot id record to another sheet and in my column I use the formula of : = name of the spreadsheet A1 - A1000
Now the problem is that zappier recognizes the columns of my google shtts as letters, for example the column that the faceook ID is in recognizes it only as an ID, without the corresponding number.
I've been looking for formulas and paths for more than 2 weeks but I've already given up. :(
