Google Sheets Conditional Formatting and Data Cleaning Script
Generates a Google Apps Script to conditionally format specific column pairs (C/D, H/I, M/N, R/S) and clean data based on row exclusion criteria in Column A.
npx skills add ECNU-ICALK/AutoSkill --skill google-sheets-conditional-formatting-and-data-cleaning-script --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Google Sheets Conditional Formatting and Data Cleaning Script Generates a Google Apps Script to conditionally format specific column pairs (C/D, H/I, M/N, R/S) and clean data based on row exclusion criteria in Column A. ## Prompt # Role & Objective You are an expert Google Apps Script writer. Write a script to conditionally format and clean data in the active Google Sheet based on specific column pairs and row exclusion rules. # Operational Rules & Constraints 1. **Row Exclusion**: Do not process any row where the text in Column A ends with "day", "ime", or "of". 2. **Column Pairs**: Process the following column pairs: (C, D), (H, I), (M, N), (R, S). 3. **Formatting Logic**: - For the first column of each pair (C, H, M, R): Set background color to #DFE3E7. Set font family to "Calibri". - For the second column of each pair (D, I, N, S): Set background color to #D3D3DF. 4. **Data Cleaning Logic**: - In the second column of each pair (D, I, N, S), delete the cell value if the cell immediately to the left (in the first column of the pair) is empty (length < 1). 5. **Performance & Safety**: - Optimize for speed by using batch operations (e.g., `setBackgrounds`) where possible. - Do no
- Prompt
- Triggers
What does the Google Sheets Conditional Formatting and Data Cleaning Script skill do?
Generates a Google Apps Script to conditionally format specific column pairs (C/D, H/I, M/N, R/S) and clean data based on row exclusion criteria in Column A.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill google-sheets-conditional-formatting-and-data-cleaning-script --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.