Google spreadsheet. Distribution of leads to different emails
134 USD 
Hello
All leads from the website (on WordPress) (from all forms on the site) go to a Google Sheet + are sent to one common email (via a form plugin on the site).
Since there are now two physical locations, all these leads need to be distributed equally between the two locations (i.e., to two new separate emails).
The idea is to send each new entry in the sheet alternately to one of the two locations (to one of the two emails). Even-numbered rows go to one location - odd-numbered rows go to the other location.
Our Google Sheet has several tabs - that is, each separate tab contains leads from a separate section of the site - this has historically been convenient for us.
Leads are forms with several fields.
It is necessary not just to send to a specific location that a new entry has appeared in the sheet for it (as a new lead) but to take all the lead data as a whole filled form and send it to the email. No employees from the location will access the sheet - they only receive emails with all the lead data.
There may be alternative methods to implement this. But in principle, this approach works for me.
Please suggest a solution or let me know if you can implement it as described.
Client's review of cooperation with Illia Vasilenko
Google spreadsheet. Distribution of leads to different emailsThank you for the work! Ilya made everything very convenient in Google Sheets. He explained everything in detail and recorded video instructions. Everything went well!
Freelancer's review of cooperation with Taras Kovalchuk
Google spreadsheet. Distribution of leads to different emailsA good client, clearly defined terms of reference, and the client had a complete understanding. Responded quickly and in a structured manner. Very satisfied with the collaboration.
-
3 days39 USD
3 days39 USD
Good evening, I will implement the sending of leads and related data using a script. The deadline with checks and tests is 2-3 days. The price is 1750.
-
2 days33 USD
2 days33 USD
Good day
There are two ways to solve your task:
1. We do exactly as per your description (even/odd lines). But there are risks that someone might break the logic in the future.
2. I set up a reliable script that will sequentially send all lead data to the required emails. In this case, we will fully preserve your convenient structure with different emails.
I can implement both options quickly. I also have an idea on how to make lead acquisition even more convenient for managers. Write to me - I will explain in more detail.
-
30 days111 USD
30 days111 USD
I am implementing automatic lead distribution based on the Round-robin principle (alternating 50/50) directly through Google Apps Script. This will allow you to maintain your current structure with multiple sheets and ensure the sending of complete emails with all form data without any monthly costs for third-party services.
Which specific plugin on WordPress are you using for forms (Contact Form 7, WPForms, Elementor)? This is important because we can set up the alternation at the stage of submission from the site to avoid delays, or we can leave the logic on the Google Sheets side, as you suggested, to ensure 100% synchronization between the entry in the sheet and the email to the manager.
Budget and timelines are in personal correspondence. 🤝
-
2 days45 USD
853 48 0 2 days45 USD
Hello!
I am interested in your project and ready to complete it.
I have been working with Google Sheets for over 5 years and have significant experience in:
• developing custom solutions,
• creating templates,
• automating processes,
• integrating with third-party services,
… • developing complex formulas and scripts (Google Apps Script).
I am ready to discuss the details and find the best solution for your task. Let's communicate :)
-
2 days67 USD
2341 73 0 2 days67 USD
Good day! I have been specializing in creating high-quality websites on WordPress for over 8 years. My work is characterized by full cross-browser compatibility, responsiveness to any devices, clean and valid code, as well as high loading speed. I am ready to start working immediately after agreeing on all project details.
✉️ Always available and open to communication
🎨 Cross-browser and responsive layout
Creating plugins/widgets/themes from scratch
🧩 WooCommerce | Contact Form 7 | Elementor | Yoast SEO | ACF | Polylang
🎯 Proper SEO optimization
-
1 day45 USD
1872 9 0 1 day45 USD
Hello.
I read the description, the task is clear. I will describe how I see it and suggest a couple of options.
Your approach (even/odd rows) works and can be implemented in Google Apps Script directly on your spreadsheet without additional services and plugins. The script triggers on a new form submission, reads all fields, forms an email with the full content of the form, and sends it to one of two locations depending on the counter.
Alternatives are worth considering.
The evenness of rows works simply, but there is a nuance: if one of the lead sheets has significantly more entries, one location may receive disproportionately many over the period. Options:
A global counter for all sheets together, exactly 50/50 between locations regardless of the form.
Distribution by geography or area code, if it makes sense for the business.
Distribution by days of the week (Monday, Tuesday, Wednesday to one location, Thursday, Friday, Saturday to another).
If there are no strong advantages in client geolocation, even/odd with a global counter will be the most accurate.
… What I will add to the basic solution.
A column "sent to location" will appear in the spreadsheet with a label A or B, so you can see the distribution and review the history.
Error logging: if the email did not send (Gmail rate limit or another error), the script tries again and marks it in a separate column for manual checking.
An email template with all form fields in logical order, with a subject like "New lead from form X, location A".
We can do a demo. I will set up a workflow on one of the sheets with test data in your spreadsheet. You will see how the emails come in, what the template looks like, how it is marked in the spreadsheet. No upfront payment, in your real environment.
A few questions for the end.
What form plugin do you use on the site (Contact Form 7, Gravity Forms, WPForms, other)?
Should I leave a duplicate on the general email, or only to the two locations?
Global counter between sheets or local for each sheet?
I await your response in private.
-
1 day45 USD
3088 31 0 1 day45 USD
Hello. I can create a script that will send the necessary data. If it's relevant, write to me, and we will discuss.
-
1 day22 USD
265 1 day22 USD
I have extensive experience with lead processing automation, Google Sheets, WordPress, and integrations through Apps Script / Make / webhook solutions. Your task can be implemented without any problems — the system will automatically distribute new leads between two locations in turn and send a fully completed application with all form fields to the corresponding email. I will also take into account that you have several sheets in the table and different forms from various sections of the site.
The solution can be made in several ways: through Google Apps Script directly with the table, through Make, or through logic on the WordPress/plugin side. The most stable option here seems to be through Google Sheets + Apps Script, where the correct order of distribution between locations will be maintained and each sheet in the table will be processed separately.
I suggest moving to personal messages for a more detailed discussion of the terms of reference, implementation method, and integration details.
-
1 day45 USD
9944 117 0 1 day45 USD
Hello.
I have experience with automations in Google Spreadsheet. I am ready to take it on. Write to me, we will discuss.
-
1 day33 USD
1362 3 0 1 day33 USD
I see you have WordPress + Google Sheets, leads from different sections of the site in separate sheets. This is a classic task for Google Apps Script - without unnecessary integrations. The script triggers on a new row, extracts all form fields, creates a sheet, and sends it to the required address based on the row parity. I did something similar for a network of auto service stations: there were three locations, and the script distributed requests in turn, emails came with all the data, no misses for six months. Here you have two sheets - even simpler. One clarification: what email should be used for sending? Your domain's Gmail or a third-party SMTP? This affects the limit on the number of emails.
-
3 days22 USD
432 1 0 3 days22 USD
Hello! I will implement automatic lead distribution 50/50 through Make.com or n8n.
I will set up a scenario that will monitor all the emails in your Google Sheet. Each new application will be automatically checked for parity and instantly sent to the email of the corresponding location with all the form data.
I am ready to discuss the details and start right away!
-
1 day56 USD
223 1 day56 USD
I have been working exclusively with Google Apps Script for many years. There are several options to solve your issue. Through a web app, if possible, or through triggers. We can format the email in a tabular form and work with fonts and colors.
-
3 days21 USD
94 8 1 2 3 days21 USD
Good day, Taras.
As an option, we can set up a trigger that activates when a new row appears in the table, which will run a script that performs the following actions:
- checks whether the row is even/odd
- depending on the result, it will send the data from the row to the corresponding email via the MailApp service.
In my opinion, this is the best solution.
-
2 days16 USD
1312 37 0 2 days16 USD
Good day. I have experience in creating Google Sheets and writing Google Apps Script. I would be happy to collaborate.
-
2 days89 USD
4461 102 0 2 days89 USD
Good day. I fully understand the task. I will be happy to help. I will complete everything quickly and efficiently!
-
3 days22 USD
4975 41 4 1 3 days22 USD
Good day!
I professionally create solutions for automating business processes. I am ready to implement automatic lead distribution from your Google Sheets to two separate email addresses, using the specified logic (even/odd rows). I have experience with Google Sheets API and Google Apps Script.
Message me privately, and we will clarify the details.
-
2 days33 USD
1901 53 0 2 days33 USD
Hello! I am ready to complete your task, I have experience working with similar tasks.
-
2 days78 USD
96304 1273 1 10 2 days78 USD
Hello. I have extensive experience with WordPress. I am ready to implement the changes.
-
2 days45 USD
86 2 days45 USD
Good day, the easiest way to implement your task is on Google Apps Script. The script will track all new rows and depending on the row number, it will send a message to Email. For the email template, we can use Google Docs, where you can completely change the structure of the letter without the need to work with code. I will be happy to collaborate.
-
14 days28 USD
957 19 0 14 days28 USD
Good day! Your option with even/odd numbers is good. To take into account all the tabs, the data from them will need to be consolidated into one. Write back, let's try this option.
-
1 day16 USD
919 4 0 1 day16 USD
Hello, Taras, the task is generally clear. The implementation depends on how it looked for you before. But it can be implemented in various ways. For example, using Google Apps Script. Or through n8n automation. Or with a small Python script. Whatever is more convenient for you and better fits the architecture of your project. I would be happy to collaborate with you!
Current freelance projects in the category Databases & SQL
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 22 hours 45 minutes back ∙ 5 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 1 day 13 hours back ∙ 8 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 6 days 13 hours back ∙ 12 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 7 days back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 10 days 7 hours back ∙ 16 proposals |
Ukraine