Google Sheets
Publish content from Averi to a Google Sheet, with columns you choose.
Publishing to Google Sheets
Averi's Google Sheets integration appends your content to a spreadsheet of your choice. Every time you publish, Averi adds a new row to your sheet — useful for keeping a content log, feeding a headless CMS, or piping content into any workflow that reads from Sheets.
What You'll Need
Before you start:
- An existing Google Sheets spreadsheet. Averi publishes into a sheet you already have — it won't create one for you. A blank sheet is fine.
- Edit access on that spreadsheet for the Google account you'll connect. If you can't edit the sheet yourself, Averi can't either.
- The spreadsheet's URL — just copy it from the address bar when the sheet is open.
Google Sheets is currently awaiting final approval from Google's API team. When you click Connect, you'll see a notice about this with a Continue anyway button — it's safe to continue, and the integration works normally.
How to Connect
Open Integrations
In Averi, go to Integrations on the bottom left.
Connect Google Sheets
Find Google Sheets under Publishing and click Connect. On the approval notice, click Continue anyway.
Sign in with Google
You'll be redirected to Google's login screen. Sign in with the account that has access to the spreadsheet you want to use, then approve the permissions Averi needs to read and write to your sheets.
Once you're back in Averi, the configuration dialog opens automatically.
Paste Your Spreadsheet URL
In the Google Sheets URL field, paste the full URL to your spreadsheet — it looks like https://docs.google.com/spreadsheets/d/1ABC.../edit. Averi will confirm the spreadsheet and show its name with a green checkmark.
Pick a Sheet
Use the Select Sheet (Tab) dropdown to choose which tab in the spreadsheet to publish to. If your file only has one tab, it'll already be selected.
Click Next to continue.
Map Your Columns
This is where you tell Averi which columns to drop each piece of content into. Pick the column letter (A–Z) for each field you want included.
Always included:
- Title — the content's title. Defaults to column A.
- Content — the body of the article as HTML (with formatting like headings, bold text, and images preserved). Defaults to column B.
Included by default, can be turned off:
- Updated date — the date the content was last updated, in
YYYY-MM-DDformat. - Publish date — the date the content was published, in
YYYY-MM-DDformat.
Optional:
- Featured image — the first image from your content, as a URL. When turned on, that image is removed from the body so it doesn't appear twice.
- Slug — the URL-friendly version of your title (e.g.
my-blog-post). - Meta description — the SEO summary from your content's metadata.
- Read time — the estimated reading time.
Each field goes into its own column, and Averi won't let you assign the same column to two fields.
Send a Test Row
Click Send Test to push a sample row into your sheet. Open your spreadsheet to check that everything landed in the right columns. If anything looks off, go back and adjust your mapping.
Save Your Configuration
Click Complete to save. You can re-configure your integration at any time by heading back to the Integrations page and clicking Configure on the Google Sheets integration.
Publishing Content
Once connected, push content to Google Sheets by clicking Send to CMS in the editor or Publish from the finalized column in your workspace.
Averi finds the next empty row in your selected sheet and appends a new row with your content, using the column mapping you set up. Existing rows are never overwritten. Your Google Sheet will fire alongside any other active integrations you have connected.
If you want to schedule and auto-publish posts from Averi through Google Sheets, make sure Auto-Publish is toggled to ON in your Integrations page.
Tips
- Add your own header row. Averi doesn't create headers for you. If you want column labels like "Title" and "Content" at the top of your sheet, add them to row 1 before you start publishing.
- HTML shows as plain text. Google Sheets doesn't render HTML, so the Content column will contain the raw markup (like
<h2>and<p>tags). That's intentional — it keeps formatting intact for downstream systems that do render HTML. - Append only. Every publish adds a new row to the bottom. Averi won't edit or replace anything already in your sheet.
- Reconfigure anytime. Head back to Integrations to change your sheet, switch tabs, or adjust your column mapping.
Troubleshooting
- "Could not access spreadsheet" — Confirm the Google account connected to Averi has edit access to the spreadsheet. View-only access won't work.
- Wrong sheet tab — Make sure you selected the correct tab during setup. You can change it from Configure on the Integrations page at any time.
- Featured image missing — The Featured image field must be enabled in your column mapping, and your content needs at least one image for Averi to pull from.
- Slug or meta description not showing — Make sure the corresponding field is toggled on in your column mapping, and that those fields are filled in on the content itself.
- Content appearing in the wrong columns — Re-open the configuration and verify each field is mapped to the column letter you expect. Use Send Test to confirm.
Need Help?
Reach out to us at [email protected] - you'll always get a human to talk through solutions with.