I’mtrying to get access to all hyperlinks in my sheet using python and gsheet api v4. But fields=’sheets/data/rowData/values/hyperlink’ not working, valueRenderOption=FORMULA not working because there is no formulas in cells

I found a great budget template called « The poor man’s budgeting spreadsheet » that allows me to split my budget into per day-allowance and compensates over or under spending my daily allowance by adding or substracting it from the next day. Each lign represents one day but I would like to be able to add multiple lines for multiple expenses on the same day without it ruining the daily allowance mechanics. How to add a lign while making google sheets understand that as long as the expenses are on the same day, they should be substracted from the same daily allowance.

I have a couple of sheets that won’t scroll all the way to the right to display the last column in full. I have tried adding in columns beside it & adjusting the width.

I have a couple of sheets that won’t scroll all the way to the right to display the last column in full. I have tried adding in columns beside it & adjusting the width.

How can i create a pivot table filter using python, like filter by “namecolumn1″” == 1 | 2. I’ve tried searching in the API documentation but idk how to do it.