Data processing and filling out tables
What needs to be done
There is a ready-made Google Sheets template with 4 sheets. You need to fill in similar tables for 3 other types of services based on the example.
Input
- Example of a filled file (template)
- List of keywords for each type of service
- List of headlines and descriptions (that performed well)
- Instructions
What needs to be filled in for each type of service
Sheet 1 — ads_data (main):
- Distribute keywords into ad groups (Ad Group)
- For each row, write Headline 1 (based on the keyword)
- Fill in Headline 2–15, Description 1–4, Path 1–2, Final URL (according to the template)
Sheet 2 — keywords_phrase:
- List of keywords with Phrase match type
- Distributed into ad groups
Sheet 3 — keywords_exact:
- The same list with Exact match type
Sheet 4 — ads_export:
- Formulas are already set up, data is pulled automatically
Scope
- 3 types of services
- Approximately 20–30 keywords for each type
- For each: 1 filled Excel file
Execution time
For a person with experience in spreadsheets, this task will take 3–4 hours. A detailed instruction will be provided after we agree on cooperation.
Requirements
- Carefully adhere to the structure of the template
- Do not break the formulas
- Check the length of headlines (up to 30 characters) and descriptions (up to 90 characters)
Tools
You can and should use AI to speed up the work: grouping keywords, generating headlines, checking text length. Preferably Claude or Gemini (not ChatGPT).
https://docs.google.com/spreadsheets/d/1NuvwhmdqBraQ77rd_Wg_MJyWqcBOKqHY8OK6KUgmUm0/edit?usp=sharing
https://drive.google.com/file/d/1_j0aUgKZ2TOqPlU0G0cHubWq-Mv8Gv6A/view?usp=sharing
https://drive.google.com/file/d/1WgT4sopJPVo2de6WJsRVGTqijW8hZH4F/view?usp=sharing
https://drive.google.com/file/d/1Ftrv6Enx9N2u3B9ufz4vVSk-t0n1AWVr/view?usp=sharing
video instructions on how to do the work
all links to the necessary data
https://docs.google.com/spreadsheets/d/1M9i38CuRm724QiFsRpw8dw1EqHNezHIm7faReuNm2l4/edit?usp=sharing - keywords
https://docs.google.com/spreadsheets/d/14yGiIMwS_uJKzEOvGx3b5tC9_of5VC_JVFvDqe8MOCc/edit?usp=sharing - emissions permit
https://docs.google.com/spreadsheets/d/1akadgP_gNHFnXG-sgRrGauvG19iPWuZP1K_0KgBQ66E/edit?usp=sharing - emissions permit
https://docs.google.com/spreadsheets/d/1akadgP_gNHFnXG-sgRrGauvG19iPWuZP1K_0KgBQ66E/edit?usp=sharing Report on the effectiveness of facilities Water use permit 1
https://docs.google.com/spreadsheets/d/1m3SHli54En55bUL6fgM3ik9NakYL-qv9IQk9HbaYT-I/edit?usp=sharing Report on the effectiveness of facilities Water use permit 2
https://docs.google.com/spreadsheets/d/12G7LUc-v0iUORXOo3xZoffWRPFrd4EuuaZkDxQYSRKg/edit?usp=sharing Report on the effectiveness of facilities Waste permit
-
226 1 0 Hello!
I have reviewed the technical assignment and all the provided materials (template, instructions, keywords, filling examples, video). I am ready to complete the work in full accordance with the requirements.
What I can guarantee:
Correct filling of Google/Excel sheets strictly according to the template;
Distribution of keywords by Ad Group according to logic and example;
…
Generation of Headline 1–15 and Description 1–4 with limit checks (30 / 90 characters);
Filling of ads_data, keywords_phrase, keywords_exact sheets without damaging formulas;
Careful work with formulas and automatic data pulling in ads_export;
Attention to detail and verification before submission.
I have experience working with tables, structured templates, and Google Ads logic. To speed up and optimize, I use AI tools for grouping keywords and generating texts with length control.
I am ready to start immediately after agreeing on cooperation and to complete the task within the stated deadline.
I look forward to collaborating.
-
538 17 0 Good day. I am ready to collaborate. I use Gemini in my work.
-
772 8 0 Hello. I have reviewed the technical specifications and looked over the files.
Why me:
I understand the structure of Google Ads Editor (I work with Ad Groups, RSA, match types).
I can effectively use AI (Gemini/Claude) for keyword clustering and generating relevant headlines/descriptions, as stated in the instructions.
I will follow the template clearly and preserve the formulas.
…
I am ready to start now and will deliver within 24 hours (or sooner). The price of 1000 UAH is acceptable.
-
277 1 1 Hello! I can complete your task. Quickly, qualitatively, clearly according to the technical specifications!
-
777 17 0 Good day! I am ready to complete the work of creating Google Ads campaigns for 3 types of services.
**I understand the task:**
- Fill in 3 files according to the template (4 sheets in each)
- Process ~20-30 keywords per service
- Create headlines (Headline 1-15), descriptions (Description 1-4), URLs
- Adhere to limits: headlines up to 30 characters, descriptions up to 90
- Keep all formulas unchanged
… **My experience:**
- I work with Google Sheets and Excel at a professional level
- I have experience setting up Google Ads campaigns
- I actively use Claude for optimizing work with texts
**Approach to work:**
1. I will study the template and all provided materials
2. I will use Claude for grouping keywords and generating relevant headlines
3. I will check the length of all texts and compliance with the structure
4. I will submit 3 completed files with verified data
**Deadline:** 2-3 days
**Cost:** 1500 UAH
I am ready to start after confirmation. I have received all links, and the instructions are clear!
-
2812 206 0 3 Hello. I will complete the work on time and with quality. The technical specifications have been written in detail. I work alone. There will be no problems. I am open to work.
-
727 10 1 Good day, Yevhen!
I am ready to perform your task qualitatively and accurately. I have similar experience in data processing and filling out tables.
I can start immediately after agreeing on the details. Examples of similar work: in the portfolio. I will be happy to collaborate. 👍
-
492 4 0 Hello, I transform Google Sheets into organized systems literally, I write code in Google Apps Script, and I have cases of a similar direction.
-
597 7 0 Hello! I am ready to efficiently and promptly complete your data processing task. I have experience working with Google Sheets and understand the specifics of filling out advertisements (Headlines/Descriptions). I work very carefully: I guarantee adherence to character limits and alignment of headlines with keywords.
Why you should choose me:
• Clarity: I will execute everything strictly according to your example (template).
• Speed: I can start working right now and complete the project within a few hours.
• Quality: I check each cell for logic and the absence of errors.
I would be happy to help you structure the data. I look forward to your feedback!
-
693 15 0 2 Good day! Take a look at the video partially on how it needs to be done, I will do it without problems, but considering the light 2 days!
-
436 102 12 6 Good day! I will complete this project without problems, I have been working with tables for over 10 years!