Google Sheets

Available

This integration is active and ready to use in Frihet.

Export your invoices, expenses, and tax summaries to professional spreadsheets in Google Sheets. Share reports with your accountant via a link. Import data from any spreadsheet with automatic column detection.

What it does

With Google Sheets connected:

• Export invoices — Professional invoice ledger with formulas and totals
• Export expenses — Expense log with categories and per-category summary
• Tax summary — Quarterly summary ready to share with your accountant
• Import data — Read any spreadsheet (invoices, expenses, clients, products)
• Auto-detection — Recognizes columns in Spanish and English with fuzzy matching
• Duplicate prevention — Detects duplicate records before importing

Requirements

• Google account — Gmail, Google Workspace, or Google One
• Frihet Pro or higher
• Google Sheets API enabled in Google Cloud Console (configured by the admin)

No credentials to enter

This integration uses OAuth with Google. You don't need to copy any API key or token. Simply authorize Frihet to access Google Sheets through a Google sign-in window.

Connect Google Sheets to Frihet

Step 1: Start the connection

1. Go to Settings → Integrations
2. Find Google Sheets
3. Click Connect with Google

Step 2: Authorize in Google

1. The Google sign-in window will open
2. Select your Google account
3. Review the permissions requested:
   • Create and edit spreadsheets in Google Sheets
   • View and manage files created by the app in Google Drive
4. Click Allow

Step 3: Verify connection

1. Back in Frihet, you'll see "Connected" next to Google Sheets
2. The export and import actions will be available
3. The integration is ready to use

How it works

Frihet uses the Google Sheets API v4 with an OAuth 2.0 authorization flow:

1. You click "Connect with Google" and authorize in the Google window
2. Google generates access and refresh tokens
3. Frihet stores both tokens encrypted (AES-256-GCM)
4. With the access token, Frihet can create spreadsheets and read existing ones
5. The token refreshes automatically when it expires
6. You never enter Google credentials directly in Frihet

Synced data

Data	Direction	Frequency
Export invoices	Frihet → Google Sheets	On demand
Export expenses	Frihet → Google Sheets	On demand
Export tax summary	Frihet → Google Sheets	On demand
Import data	Google Sheets → Frihet	On demand

Export to Google Sheets

Export invoices

Creates a professional spreadsheet with 3 sheets:

Sheet 1: Invoices

Column	Description
Invoice No.	Invoice number
Client	Client name
Tax ID	Client tax ID
Date	Issue date
Due Date	Due date
Net Amount	Subtotal before taxes
VAT %	VAT rate applied
VAT	VAT amount
Withholding %	Income tax withholding
Withholding	Withholding amount
Total	Total amount
Status	Draft, sent, paid, overdue

Includes:

• Totals row with SUM() formulas
• EUR currency formatting
• Conditional formatting: paid (green), overdue (red), draft (gray)
• Auto-filter on all columns
• Frozen header row

Sheet 2: Tax Summary

Breakdown by quarter (Q1-Q4):

• Net amount per quarter
• Output VAT
• Withholding retained
• Annual totals

Sheet 3: Line Item Detail

One row per invoice line (expanded):

• Invoice No., Description, Quantity, Unit Price, Subtotal, VAT

Export expenses

Creates a spreadsheet with 2 sheets:

Sheet 1: Expenses

• Invoice No., Vendor, Date, Description, Category, Net, VAT, Withholding, Total, VAT Rate
• Conditional formatting by category
• Auto-filter and totals row

Sheet 2: Summary by Category

• Expense breakdown by category with totals

Export tax summary

Creates a complete spreadsheet for your accountant with 3 sheets:

• Tax summary (income + expenses + Modelo 303 estimate)
• Issued invoices
• Received invoices (expenses)

How to export

1. Go to Settings → Integrations → Google Sheets
2. In the Data tab, choose the export action
3. Frihet creates the spreadsheet in your Google Drive
4. It opens automatically in a new tab
5. The link is copied to your clipboard to share

Import from Google Sheets

Supported data types

Type	Auto-detected columns
Invoices	invoice, client, tax id, date, total, VAT, status
Expenses	vendor, date, description, category, amount, VAT
Clients	name, tax id, email, phone, address
Products	name, description, price, VAT

Automatic column detection

Frihet recognizes headers in Spanish and English with fuzzy matching. Examples:

Frihet expects	Recognized headers
Date	fecha, date, issue date, fecha emisión
Client	cliente, client, customer, name, razón social
Tax ID	nif, cif, tax id, vat, dni
Total	total, importe, amount, monto

If not auto-detected, you can adjust the mapping manually.

Import flow

1. Select spreadsheet — Choose one of your Google Drive spreadsheets or paste a URL
2. Select tab — If the spreadsheet has multiple tabs, choose the right one
3. Column mapping — Frihet auto-detects data type and columns. You can adjust.
4. Preview — Review parsed data with validation warnings
5. Import — Records are created in Frihet

Duplicate detection

Before importing, Frihet compares data with your existing records:

• Compares by invoice or document number
• Shows warnings for potential duplicates
• You can skip duplicates or overwrite them

Use cases

Share with your accountant

Export the quarterly tax summary to Google Sheets. Share the link with your accountant. They get instant access to invoices, expenses, and tax estimates in a format they already know.

Migrate from another system

You have invoices in an Excel exported from Holded, Billin, or any other program. Upload it to Google Sheets, connect with Frihet, and the importer recognizes the columns automatically. In minutes, all your data is in Frihet.

Custom analysis

Export your data to Google Sheets and create charts, pivot tables, or custom formulas that aren't (yet) in Frihet. The best of both worlds.

Troubleshooting

"Error connecting with Google"

• Verify your Google account is active
• If you use corporate Google Workspace, your admin may have restricted third-party apps
• Check that you don't have popup blockers

"No data was exported"

• Verify you have invoices or expenses created in Frihet
• Check that the Google session hasn't expired
• If the error persists, disconnect and reconnect Google Sheets

"I can't see my spreadsheets when importing"

• Only Google Sheets spreadsheets are listed (not Excel or CSV)
• Verify the spreadsheet is in your Google Drive (not just shared with you)
• For shared spreadsheets, add them to "My Drive" first

"The importer doesn't detect columns"

• Verify the first row contains column names (headers)
• Headers must be in row 1 of the sheet
• Try more descriptive headers (e.g., "Date" instead of "D")
• You can adjust the mapping manually if auto-detection fails

"Session expired"

• Google may request re-authorization periodically
• Go to Settings → Integrations → Google Sheets and click Reconnect

"I want to disconnect"

1. Go to Settings → Integrations → Google Sheets
2. Click Disconnect
3. Tokens are deleted from Frihet
4. Optionally, revoke access at myaccount.google.com/permissions

Next steps

• Connect Google Drive to manage files
• See the REST API for programmatic access