Google Sheets API in C# console application - Update range in filter in sheet
Budget: $30 – $250 USD
I need a sample console application written in C# using VS 2022 that will update the range of all filters on a specific tab in a google sheet to include all rows currently in the tab. The filter attributes itself should stay the same .
The use case is when a new row is added via the Google API to an existing sheet, the filter range is not updated so the new row is not included in the filter. I need to modify all filters that exist on the sheet to include all rows in its range using the API.
You should use the most up to date Google.Apis.Sheet.v4 Nuget package in your project.
https://developers.google.com/api-client-library/dotnet/apis/sheets/v4
Your app.config should contain following settings required by the API Service_Account_Name; Google_Spreadsheet_Id, Google_JSON_Creditional_Path You should create your own google cloud api access and test sheet. I will NOT provide these.
Below is a stackoverflow article that covers what I am trying to do with a suggested solution you may build upon if able.
https://stackoverflow.com/questions/64346131/script-to-update-multiple-google-sheet-filter-view-ranges
The use case is when a new row is added via the Google API to an existing sheet, the filter range is not updated so the new row is not included in the filter. I need to modify all filters that exist on the sheet to include all rows in its range using the API.
You should use the most up to date Google.Apis.Sheet.v4 Nuget package in your project.
https://developers.google.com/api-client-library/dotnet/apis/sheets/v4
Your app.config should contain following settings required by the API Service_Account_Name; Google_Spreadsheet_Id, Google_JSON_Creditional_Path You should create your own google cloud api access and test sheet. I will NOT provide these.
Below is a stackoverflow article that covers what I am trying to do with a suggested solution you may build upon if able.
https://stackoverflow.com/questions/64346131/script-to-update-multiple-google-sheet-filter-view-ranges