Freelance projects

Freelance projects

Transfer of customer data from Google Docs to Meta Conversion API

Bot Development, Data Processing — incorrectly specified categories?

90 USD

Client's review of cooperation with Oleg N.

Transfer of customer data from Google Docs to Meta Conversion API

90 USD

Thank you, Oleg.

Everything is clear, understandable, with explanations in a topic that is difficult for me. No AI responses at the stage of bids and agreements (unlike 90% of candidates). I recommend.

5.0

Danilo Danilo

Reciprocal Feedback

10 January

Freelancer's review of cooperation with Danilo Danilo

Transfer of customer data from Google Docs to Meta Conversion API

90 USD

Everything is great! A good client. Clear terms of reference, good communication, fast payment. Thank you for your trust.

5.0

Oleg N.

Reciprocal Feedback

10 January

Project translated automatically. Log in or register, to view the original

Task Description:

Set up automatic data transfer from Google Docs to the Meta Conversion API for recording purchases in the Telegram chatbot. All customer data is located in a Google Docs spreadsheet, where clients who made a purchase through the chatbot or were added manually are recorded.

Main Requirements:

Data Source:
- There is a Google Docs spreadsheet containing customer data.
- The spreadsheet has the following columns:
  - Date
  - First and Last Name (or just first name, or just last name)
  - Phone Number (numbers from different countries, mainly - Ukraine, Europe, Britain, States)
  - FBCID parameter (unique identifier from Facebook for tracking purchases from ads).
Data Transfer to Meta Conversion API:
- Once all parameters are filled, a switch labeled "ready" must be activated in a specific column of the spreadsheet.
- When the switch is activated, the data must be automatically transferred to the Meta Conversion API for recording the purchase.
- It is important that this data includes:
  - First and Last Name (or just one of these fields)
  - Phone Number
  - FBCID (obtained from Facebook/Instagram ads).
Technical Details:
- Data Hashing: To ensure privacy, all personal data (e.g., name, surname, and phone number) must be encrypted (hashed) before sending to the Meta Conversion API. Use the SHA-256 algorithm or other hashing standards recommended by Meta.
- Meta Conversion API: Data transfer must comply with all requirements of the Meta Conversion API for conversion tracking. Check the current documentation for the exact request format and data requirements.
- Google Docs and Make: The integration must be set up using Make, which allows for automatic reading of data from the spreadsheet and transferring it to the Meta Conversion API.
Technical Instructions for Integration:
- Use Make to automate the data transfer process:
  - Connect Google Docs through Make to monitor changes in the spreadsheet (check for changes in the "ready" column).
  - After activating the "ready" switch, Make should retrieve the values from the spreadsheet and send them to the Meta Conversion API.
- Consider that it is necessary to:
  - Check if all mandatory data is filled (name, surname, phone, FBCID).
  - If the data is incomplete or incorrect, the system should handle errors (not send incomplete records).
Testing and Refinement:
- Test the process with real data, check if the integration works correctly.
- After setup, conduct a test run with real customers to ensure that all data is transmitted correctly and conversions are recorded in Facebook.
- Ensure a normal/high event matching quality rate.
- If something is not working, refine it.

Proposals 8 Rejected 5

Yaroslav G.

8 0

Budget: 8000 UAH Deadline: 14 days

Hello, Danilo.

I propose to implement this task using Google Apps Script instead of Make. For the Meta CAPI task, this provides two critical advantages:
1. High Event Match Quality: Meta requires complex normalization of numbers and hashing (SHA-256) before sending. This is done much cleaner and more accurately with a script than with Make blocks, ensuring that Facebook recognizes the customer.
2. Cost savings: the solution will work for free, as Google Apps Script has significantly higher limits on free accounts than Make.

I have extensive experience integrating various systems via API using Google Apps Script. I create reliable solutions with data validation and logging.

Maksym T.

1 0

Projects -
Rating -
Rating 435

Budget: 4500 UAH Deadline: 7 days

Hello, Danilo!

I can set up automatic data transfer from Google Sheets to Meta Conversion API via Make.com.

What I can do:

1. Tracking the "ready" column in Google Sheets;
2. Checking mandatory data (first name/last name, phone, FBCID);
3. Hashing personal data and sending the event to Meta Conversion API;
4. Logging, error handling, and testing with real data.

I would be happy to discuss the details and offer an optimal solution.

Oleg N.

Winning proposal

53 0

Budget: 4000 UAH Deadline: 5 days

Hello! I am ready to complete your task, I have experience working with similar projects.

Roman Diachuk

2 0

Projects -
Rating -
Rating 945

Budget: 20000 UAH Deadline: 10 days

Hello! Can you tell me if the phone numbers in the table are already in a single international format (with a plus and country code), or will I need to add logic in Make for their cleaning and formatting before hashing?

I have 4 years of experience working with Python and complex API integrations, so I understand the technical requirements of Meta for data transmission and the SHA-256 algorithm well. I often set up automations specifically through Make, combining Google Sheets with CRM and advertising accounts. I will do everything to ensure you receive a high event match quality score in the Facebook account.

I would be happy to help set everything up. When is it convenient for you to chat and discuss the details?

Yevgeny Gordadym

601 0

Budget: 20000 UAH Deadline: 5 days

Good day, I can do this. Many times I have triggered the Purchase event, I will automate your process according to your rules...

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Yurii Kolesnyk

13 0

Budget: 6000 UAH Deadline: 8 days

Hello, I can implement your task using the Make.com platform, create an automation that will retrieve data from a table, filter its correctness and availability, hash it using the SHA-256 algorithm, mark in the table the data that has already been transmitted, I can also help set up the Pixel (event manager in Facebook) for uploading your data there, as well as setting up advertising that will target this data for converting leads of better quality, which are most oriented towards your products or services, because this is why data is transmitted to the Pixel (event manager), I have already implemented such projects, and specifically through the Make.com platform, if you are interested, please contact me.
Why 8 days? The specifics of Meta, I will also explain in private messages.

Mykola Lykhobaba

1 0

Projects -
Rating -
Rating 228

Budget: 8000 UAH Deadline: 3 days

Hello! I have reviewed the task description — I have practical experience integrating Google Sheets → Meta Conversion API through Make, including for tracking purchases from chatbots and improving event matching quality.

I can fully implement this solution considering all technical requirements from Meta.

How I propose to implement it:
1. Data source (Google Sheets)

Connecting the spreadsheet through Make

Monitoring changes in the "ready" column

The trigger activates only when the switch is turned on

Checking mandatory fields:

first name / last name (one of the fields is acceptable)

phone number (international format)

FBCID

If the data is incomplete or incorrect — the record is not sent, errors are logged

Transmission to Meta Conversion API

Creating a Purchase event

Preparing the payload according to the current Meta documentation

Hashing personal data (SHA-256):

first name

last name

phone number

Correct transmission:

fbc

event_time

action_source

Monitoring the response status from Meta

Make (Integromat)

Scenario:

Google Sheets → filters → hashing → HTTP request to Meta CAPI

Error handling:

retries

logging failed submissions

Scalability (adding new events in the future)

Testing and adjustments

Test events through Meta Events Manager

Verification:

correctness of events

Event Match Quality

Test run on real data

Adjusting logic in case of issues (matching, formats, fields)

Result

Fully automated transmission of purchases from Google Sheets to Meta

Correct hashing of personal data

High event matching quality

Stable integration without manual involvement

Timeline and cost

Timeline: 3–5 working days

Cost: $200–350 (depends on the number of tests and adjustments)

Ready to start immediately after access to the spreadsheet, Make, and Meta Events Manager.
If needed, I can briefly describe the scenario in a diagram before starting.

Dmytro Romanchuk

10 0

Budget: 1000 UAH Deadline: 1 day

Good day, I have experience working with Python as well as Telegram bots, I can complete everything quickly and efficiently, write to discuss the details.

Nick Osipov

41 4

Budget: 10000 UAH Deadline: 7 days

Good day.
I professionally develop software in Python. I have experience working with third-party APIs and Google Docs.

Write to me in private messages.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Bot Development

Signal bot for trading

Python 69 proposals 31 July

67 USD
Creation of an OLX bot

59 proposals 30 July

Not specified
Create an SEO system based on n8n

AI & Machine Learning 58 proposals 30 July

Not specified
Парсинг маркетплейсу

Data Parsing 38 proposals 30 July

38 USD
Post reposting bot for Telegram

91 proposals 28 July

69 USD

Danilo Danilo
Kyiv, Ukraine

Projects 51
Contests 1
Rating 5.0
Rating 1 119

Danilo Danilo

Oleg N.

Yaroslav G.

Maksym T.

Oleg N.

Roman Diachuk

Yevgeny Gordadym

Proposals are currently absent

Yurii Kolesnyk

Mykola Lykhobaba

Dmytro Romanchuk

Nick Osipov

Current freelance projects in the category Bot Development

Signal bot for trading

Creation of an OLX bot

Create an SEO system based on n8n

Парсинг маркетплейсу

Post reposting bot for Telegram