- Go to Google Cloud Console.
- Create a new project (or use an existing one).
- Enable the Google Sheets API:
- Navigate to
APIs & Services>Library. - Search for Google Sheets API and enable it.
- Navigate to
- Generate an API Key:
- Go to
APIs & Services>Credentials. - Click
Create Credentials>API Key. - Copy the generated API Key.
- Go to