Source: Google Sheets

The “Google Sheets” source reads data from an online spreadsheet and saves it as the working source file. It is useful for price lists, stock files, dictionaries, and other data maintained in Google Sheets by your team or supplier.

Two access options

• Public spreadsheet by link - link access is enabled in Google Sheets, so Eofferix only needs the document URL.
• Private spreadsheet - a Google service account is used. Paste the JSON key into Eofferix and share the spreadsheet with the service account email.

Public spreadsheet setup

1. Open the Google Sheet and copy the URL from the browser address bar.
2. Enable view access by link in Google Sheets if this is acceptable for the data.
3. Create a “Google Sheets” source in Eofferix and paste the URL.
4. If a specific tab is needed, fill in “Sheet”. If it is empty, Eofferix will try to use the gid from the URL or the first sheet in the document.
5. Run the access check and then fetch the file.

Private spreadsheet setup

1. Create a service account in Google Cloud for the integration.
2. Enable the Google Sheets API for the project.
3. Create a service account JSON key and paste it into “Service account JSON”.
4. Find client_email in the JSON and share the spreadsheet with that email as Viewer.
5. Check access in Eofferix and fetch the file.

What to check after fetching

• The source card shows a working file.
• For table-like data, the header row and sheet selection block becomes available below.
• The data comes from the correct sheet, especially when the document has several tabs.

Common mistakes

• The spreadsheet is private but not shared with the client_email from the JSON.
• The JSON key is incomplete or belongs to another project.
• The “Sheet” value does not match the tab name in Google Sheets.