Google Sheets API in C# E1: OAuth2 Authentication and First Sheet Creation

In this tutorial video, we will learn how to use the Google Sheets API in C# to create a new Google Sheet and authenticate with OAuth2. This is the first episode in a series that will cover different aspects of using the Google Sheets API in C#. We will start by setting up the necessary credentials in the Google Cloud Console and using the Google API Console to create a new project and enable the Google Sheets API. Then, we will use the OAuth2 library to authenticate our application and access the Google Sheets API. Once we have authenticated, we will create a new Google Sheet programmatically and retrieve its identifier and URL. By the end of this video, you will have a good understanding of how to use the Google Sheets API in C# to create Google Sheets programmatically. Stay tuned for the next episode in this series, where we will cover more advanced topics like updating and deleting sheets, working with ranges, and more.
Timestamps:
00:17 - Google Cloud Console project selection/creation
00:35 - Enabling the Google Sheets API library
00:55 - Creating a OAuth Client ID for authentication purposes
01:27 - Google.Apis.Sheets.v4 Nuget package installation
01:44 - Google Sheets API OAuth2 Authentication
03:20 - Interface creation to define methods to be implemented
03:35 - Class creation implementing the defined interface
03:55 - Constructor Injection Pattern for Google UserCredential instance
04:10 - Google Sheet creation method implementation
05:07 - Testing the implemented function
Source code link:
www.gmb-api.co...