burnash / burnash/gspread

Add support for Conditional Formatting

Open
#525 7 comments 5 reactions 0 assignees View on GitHub
good first issue Improvement
Dominant language
Python
Stars
7.5k
Forks
979
PR merge metrics
No merged PRs in 30d

Description

Hey,

Thanks for making this library, it has significantly lowered the bar to working with Google Sheets for me. It would be awesome to have support for Conditional Formatting on columns.

https://developers.google.com/sheets/api/samples/conditional-formatting

It looks like it could fit well in to the `range` style notation, with some kwargs for the formatting options. If I get a chance I will create a PR.

Contributor guide

Open the contributing guide

Research direction

Start with the linked Google Sheets API conditional-formatting sample and inspect how gspread represents range styles. Determine how column conditional formatting and its formatting options should fit the proposed range-style notation. Done means users can create conditional formatting for columns through the library.

Written by the indexing model from the issue text.

Assessment

Tech stack
google-cloud, python
Domain
api
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
32/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.