Enhance Google Sheets for Keyword Research
Budget: ₹600 – ₹1,500 INR
Subject: Help Needed for Google Sheets Keyword Research Workbook
Hi, Hope you're doing well! ?
I need your help with my project called Keyword Research Workbook for SEO and Google Ads. This workbook is designed for educational purposes, helping new SEO and Google Ads learners conduct keyword research step by step. It ensures they don’t miss anything and helps them organize keywords efficiently in one place.
Project Details:
✅ Format: Google Sheets
✅ Total Sheets: 8 Pages
Instruction & How to Use
Set Goals & Define Target Audience
Break Down Target Audience into Segments
Brainstorm & Collect Keywords (Need Help Here)
Prioritize & Filter the Best Keywords
Group Keywords into Clusters (Themes)
Map Keywords to Content, Ads, or SEO Strategy
Track Performance Over Time & Improve
Before reading further, please review my workbook to get a clear idea of the project:
? Workbook Link: https://docs.google.com/spreadsheets/d/1mzRzijXlFgyRaKBYcWBS94D--2FQcesOOxR-4C3xPQU/edit?usp=sharing
I’ve already created a basic draft—you don’t have to start from scratch. I just need help with one specific sheet:
Required Skills:
Google Sheets Advanced Formulas
Google Apps Script (JavaScript)
CSV Data Handling
Google Sheets UI/UX
Debugging Apps Script
Task: Enhance "Brainstorm & Collect Keywords" Sheet
I need three main functions on this page:
1️⃣ Import Data from CSV
Import keyword data from a CSV file into the table.
The CSV header names may vary depending on the platform (Google Ads, SEMrush, etc.). The function should adapt to different headers but only extract the following 4 key metrics:
Keyword → Import to "Relevant Keyword" column
Search Volume → Import to "Volume" column
Competition Score → Import to "KD-Score" column
Cost-Per-Click (CPC) → Import to "CPC" column
I have already added a pre-built table in the sheet, but if you think a different table structure would make it easier for scripting, feel free to modify it.
2️⃣ Export Data to Another Sheet
When a checkbox is selected, and the user clicks “Export Data”, the selected row should copy to the "Prioritize & Filter the Best Keywords" sheet.
The exported data should retain the same structure.
3️⃣ Keyword Filter
I need a filter function that allows users to sort & search keywords based on criteria like Volume, CPC, KD-Score, etc.
Let me know if you have any questions or suggestions!
Looking forward to working with you.
Thanks,
Eswar Ravi
Hi, Hope you're doing well! ?
I need your help with my project called Keyword Research Workbook for SEO and Google Ads. This workbook is designed for educational purposes, helping new SEO and Google Ads learners conduct keyword research step by step. It ensures they don’t miss anything and helps them organize keywords efficiently in one place.
Project Details:
✅ Format: Google Sheets
✅ Total Sheets: 8 Pages
Instruction & How to Use
Set Goals & Define Target Audience
Break Down Target Audience into Segments
Brainstorm & Collect Keywords (Need Help Here)
Prioritize & Filter the Best Keywords
Group Keywords into Clusters (Themes)
Map Keywords to Content, Ads, or SEO Strategy
Track Performance Over Time & Improve
Before reading further, please review my workbook to get a clear idea of the project:
? Workbook Link: https://docs.google.com/spreadsheets/d/1mzRzijXlFgyRaKBYcWBS94D--2FQcesOOxR-4C3xPQU/edit?usp=sharing
I’ve already created a basic draft—you don’t have to start from scratch. I just need help with one specific sheet:
Required Skills:
Google Sheets Advanced Formulas
Google Apps Script (JavaScript)
CSV Data Handling
Google Sheets UI/UX
Debugging Apps Script
Task: Enhance "Brainstorm & Collect Keywords" Sheet
I need three main functions on this page:
1️⃣ Import Data from CSV
Import keyword data from a CSV file into the table.
The CSV header names may vary depending on the platform (Google Ads, SEMrush, etc.). The function should adapt to different headers but only extract the following 4 key metrics:
Keyword → Import to "Relevant Keyword" column
Search Volume → Import to "Volume" column
Competition Score → Import to "KD-Score" column
Cost-Per-Click (CPC) → Import to "CPC" column
I have already added a pre-built table in the sheet, but if you think a different table structure would make it easier for scripting, feel free to modify it.
2️⃣ Export Data to Another Sheet
When a checkbox is selected, and the user clicks “Export Data”, the selected row should copy to the "Prioritize & Filter the Best Keywords" sheet.
The exported data should retain the same structure.
3️⃣ Keyword Filter
I need a filter function that allows users to sort & search keywords based on criteria like Volume, CPC, KD-Score, etc.
Let me know if you have any questions or suggestions!
Looking forward to working with you.
Thanks,
Eswar Ravi