Getting Started

To set up the Google Sheet Importer module, you must enable the Google Sheets API and create a Google Service Account for authentication.

Steps to Set Up Google Sheets API and Service Account

Step 1: Enable Google Sheets API and Create a Service Account

1. Go to the Google Cloud Console.
2. Create a new project or select an existing one.
3. Navigate to APIs & Services > Library.
4. Search for Google Sheets API and click Enable.
5. Next, navigate to APIs & Services > Credentials.
6. Click on Create Credentials and choose Service Account.
7. Enter a name for your service account (e.g., "Odoo Google Sheet Importer") and click Create.
8. In the "Grant this service account access" section, choose a role such as Editor and click Continue.
9. Click Done after the service account is created.

Step 2: Download the Service Account Credentials

1. In the Credentials page, find your service account.
2. Click on the service account and go to the Keys tab.
3. Click on Add Key > Create New Key.
4. Choose JSON as the key type and click Create.
5. The credentials `.json` file will be downloaded automatically. Store it securely.

Step 3: Share Your Google Sheets with the Service Account

1. Open the Google Sheet that you want to import data from.
2. Click the Share button in the top-right corner.
3. Share the sheet with the email address in the `.json` file, which will look like: your-service-account@your-project-id.iam.gserviceaccount.com.
4. Grant Editor access to the service account.