Thank you for the work! Ilya made everything very convenient in Google Sheets. He explained everything in detail and recorded video instructions. Everything went well!
20
0
Budget: 1750 UAH Deadline: 3 days
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.
117
0
Budget: 2000 UAH Deadline: 1 day
Hello.
I have experience with automations in Google Spreadsheet. I am ready to take it on. Write to me, we will discuss.
12
0
Budget: 1500 UAH Deadline: 2 days
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.
14
0
Budget: 5000 UAH Deadline: 30 days
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. 🤝
48
0
Budget: 2000 UAH Deadline: 2 days
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 :)
73
0
Budget: 3000 UAH Deadline: 2 days
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
11
0
Budget: 2000 UAH Deadline: 1 day
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.
32
0
Budget: 2000 UAH Deadline: 1 day
Hello. I can create a script that will send the necessary data. If it's relevant, write to me, and we will discuss.
0
0
Budget: 1000 UAH Deadline: 1 day
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.
5
0
Budget: 1500 UAH Deadline: 1 day
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.
1
0
Budget: 1000 UAH Deadline: 3 days
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!
0
0
Budget: 2500 UAH Deadline: 1 day
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.
Budget: 950 UAH Deadline: 3 days
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.
37
0
Budget: 700 UAH Deadline: 2 days
Good day. I have experience in creating Google Sheets and writing Google Apps Script. I would be happy to collaborate.
102
0
Budget: 4000 UAH Deadline: 2 days
Good day. I fully understand the task. I will be happy to help. I will complete everything quickly and efficiently!
41
4
Budget: 1000 UAH Deadline: 3 days
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.
53
0
Budget: 1500 UAH Deadline: 2 days
Hello! I am ready to complete your task, I have experience working with similar tasks.
1 285
1
Budget: 3500 UAH Deadline: 2 days
Hello. I have extensive experience with WordPress. I am ready to implement the changes.
Budget: 2000 UAH Deadline: 2 days
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.
19
0
Budget: 1250 UAH Deadline: 14 days
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.
4
0
Budget: 700 UAH Deadline: 1 day
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!
Proposals concealed
The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules