We are going to start a new article series for Google sheets using Visual Studio. Always stay tuned for all articles related to Google sheets using Visual Studio.
In this article, we will cover the below things,
- What are Google Sheets
- Compare with Microsoft Excel
- Setup a Project for Google Sheet
What are Google Sheets
Google Sheets is a Web-based application that allows users to create, update and modify sheets and share the data live online. This program is compatible with Microsoft Excel and CSV (comma-separated values) files. Data between Google Sheets is synchronized automatically.
Compare with Microsoft Excel's "Export To Excel"
As we know Excel is a desktop application. To read or edit the data in Excel we need to install MS Office in our system. For this, we need to download the Excel sheet.
Google Sheets is a browser-based application. To read or edit the data we need only permission. Data between users is synchronized automatically. There is no need to upload or download any sheet.
Setup a Project for Sheet Integration
For Google Sheet integration we need to configure the project in Google API Console. Follow the below steps,
Step 1
To integrate Sheets we need set up the Google API console. To open API console, you can hit the below URL
https://console.developers.google.com/apis
or you can do the below,
Step 2
After performing the first step, the below screen will appear,
In this screen, you will find that there are currently 185 APIs and services are provided by Google. In the second tab “Library” you will find that these are categorized as Email, Big Data, G Suite, Machine Learning, Maps etc.
Step 3
Google Sheets is one of them, you can find that in the G suite category.
Step 4
On the screen click on Google Sheets API, and the below screen appears.
Here are all the things which we need to use Google Sheets.
Step 5
Before telling you step 5, I want to talk about he above steps. There you are seeing a dropdown “Select a Project” button at the top, or the 
Button at right.
What does it mean?
According to the Google, we need a project to perform any API or Service operations.
Is this mandatory?
Yes, it is mandatory.
In the above screen click on the create project button, then the below window will appear.
Step 6
In the screen click on Create Button. Then the below screen will appear.
Here you can name a project. Google picks the project name automatically, you can change that name. You see that there is another option is the project ID. Google picks it automatically also, but you can change that name, which must be unique for Google.
Note
You can put 12 projects on Google FREE OF COST.
Step 7
I put the project name “year2018” and Project ID “pradeepk0141-year2018”. Both will be used later.
Step 8
Click on Create Button, then progress gif will display. It takes 10-20 seconds only, to create a project. After the below screen will appear,
Thus we create a project, named Year2018.
Summary
To use any Google service you need to create a new project. If you have some alternate way to achieve this kind of requirement then please let me know, or if you have some query then please leave your comments.
In the next article, we will learn the below things,
- Google Sheet Terminology
- Credentials and Authentication
- Defining Worksheet Size & Title
- Add A Worksheet
- Operations In Worksheet
- Cell-Based Operations
- Delete A Worksheet
Vilas ShendePosted Sep 8, 2018, 7:35 AM
Waiting for your upcoming article to learn: Google Sheet Terminology. Credentials and Authentication. Defining Worksheet Size & Title. Add A Worksheet. Operations In Worksheet. Cell-Based Operations. Delete A Worksheet.
Sundaram SubramanianPosted Sep 8, 2018, 12:43 AM
Nice article bro. Is it possible to implement Macros in google sheet ?
Hadshana KamalanathanPosted Sep 7, 2018, 10:55 AM
Thanks for sharing....