tr Skip to content

Connect Advanced Custom Fields and Google Sheets

Advanced Custom Fields holds the prices, dates, specs and settings that shape your WordPress content. With FlowMattic, Google Sheets becomes a second place to manage them: edit a column and the field on the post changes, add a row and a repeater grows, and every field change on the site is logged back to a sheet.

9 triggers 29 actions 7 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Advanced Custom Fields3 triggers

Do this in Google Sheets19 actions

1. TriggerUser Updates Post Field
2. ActionAdd New Row

When Advanced Custom Fields fires User Updates Post Field, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Advanced Custom Fields and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Advanced Custom Fields app icon Google Sheets app icon

Update a post's custom field when a sheet column changes

Keep prices or stock notes in a sheet. When the price column changes, the post ID in that row is used to update the ACF field, so the page shows the new value.

Update Specific Column ValueUpdate Post Value

Advanced Custom Fields app icon Google Sheets app icon

Add new sheet rows to a repeater field

Event dates, menu items or team members added to a sheet are appended to an ACF repeater on the page, so content editors never open the post editor.

New Spreadsheet RowAdd New Row Value to Repeater Field in Post

Advanced Custom Fields app icon Google Sheets app icon

Control a site-wide notice from one sheet cell

A banner text or holiday hours stored in an ACF options page is updated when a manager edits a single cell, without giving them WordPress access.

Update Specific Cell DataUpdate Option Value

Advanced Custom Fields app icon Google Sheets app icon

Sync every product spec from the sheet each night

A Schedule reads all rows, Iterator walks through them and each post's field is updated, a safe way to apply a whole day of changes in one pass.

ScheduleGet RowsIteratorUpdate Post Value

Advanced Custom Fields app icon Google Sheets app icon

Log every post field edit to a change sheet

Each time an editor changes a custom field on a post, a row records the post, field and new value, which helps teams trace who changed a price or date.

User Updates Post FieldAdd New Row

Advanced Custom Fields app icon Google Sheets app icon

Keep a record of options page changes

Site-wide settings such as phone numbers, addresses or default prices are logged with the new value and date, so a wrong setting can be traced and reversed.

User Updates Options Page FieldAdd New Row

Advanced Custom Fields app icon Google Sheets app icon

Mirror member profile fields in a directory sheet

When a member updates a profile field, such as their city or speciality, their row in the directory sheet is found by user ID and updated.

User Updates Profile FieldLookup Row DataUpdate Row

Set up: sheet column to post field

At the end, changing a value in your sheet's price column updates the matching ACF field on that post.

  1. Prepare the sheet

    Make a sheet with a Post ID column and a column for the field you manage, such as Price.

  2. Connect Google Sheets

    Under Connects, add Google Sheets with the account that owns the sheet. ACF runs on the same site and needs no connection.

  3. Start with Update Specific Column Value

    Create a workflow with this Google Sheets trigger, pick the spreadsheet, sheet and the Price column, then change one value so FlowMattic captures the row.

  4. Update Post Value

    Add ACF Update Post Value, map the Post ID column, enter the field name and map the new price. Test on a draft post, then switch the workflow on.

Update a post's custom field when a sheet column changes
  1. Google Sheets app icon 1. Trigger in Google Sheets Update Specific Column Value
  2. Advanced Custom Fields app icon 2. Action in Advanced Custom Fields Update Post Value

    Fields mapped from the earlier steps (a typical setup)

    From Advanced Custom FieldsTo Advanced Custom Fields
    Post ID columnPost ID
    Price columnField value: price
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

  • Use the ACF field name, not its label, when you set which field to update. The label can change, the name is what WordPress stores.
  • Repeater and Flexible Content fields come with ACF PRO. On the free plugin, map sheet rows to separate fields or posts instead.
  • A sheet edit that updates a field can fire User Updates Post Field in another workflow. If you log changes too, Filter out edits made by the sync so rows do not double up.
  • Keep the Post ID in the sheet. Without it, the workflow cannot tell which post a row belongs to.
Advanced Custom Fields app icon

Advanced Custom Fields

Integration page

Triggers (3)

  • User Updates Post FieldTriggers when a custom field on a post is updated
  • User Updates Profile FieldTriggers when a custom field on user profile is updated
  • User Updates Options Page FieldTriggers when a custom field in options page is updated

Actions (10)

  • Get Post ValueGet custom field value for given post ID
  • Get User ValueGet custom field value for given user ID
  • Get Category ValueGet custom field value for given category ID
  • Get Term ValueGet custom field value for given term slug and ID
  • Get Option ValueGet custom field value for given option name from ACF powered options page
  • Update Post ValueUpdate custom field value for given post ID
  • Update User ValueUpdate custom field value for given user ID
  • Update Option ValueUpdate custom field value for given option name in ACF powered options page
  • Add New Row Value to Repeater Field in PostAdds a new row of data to an existing Repeater or Flexible Content field value in a post
  • Add Sub Field Value in GroupAdds a sub field value to an existing Group content field value in a post
Google Sheets app icon

Google Sheets

Integration page

Triggers (6)

  • New Spreadsheet RowTrigger when a new row is added to the spreadsheet
  • New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
  • Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
  • Update Cell DataTrigger when any cell is updated in the spreadsheet
  • Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
  • Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

  • Add New RowAdd a new row with mapped data
  • Update RowUpdate existing row in specific spreadsheet with mapped data
  • Delete RowDelete row by ID in specific spreadsheet
  • Clear Row DataClear data or row by ID in specific spreadsheet
  • Lookup Row DataSearch for data in specific spreadsheet
  • Get Cell DataGet data for particular cell in specific spreadsheet
  • Update Cell DataUpdate data for particular cell in specific spreadsheet
  • Get Row CountGet total number of rows in specific spreadsheet
  • Get Row DataGet rows data from the sheet based on specified range
  • Create Spreadsheet ColumnCreate a new column in specific spreadsheet
  • Create New SheetCreate a new sheet in specific spreadsheet
  • Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
  • Copy SheetCopy a sheet to another or within the same spreadsheet
  • Get RowsRetrieve rows in JSON format for use with Iterator
  • Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
  • Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
  • Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
  • Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
  • Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Advanced Custom Fields and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Editors work in a sheet they know

Prices, specs and opening hours are managed in Google Sheets, and the site follows without anyone touching the post editor.

Both directions, one plugin

Sheets can change ACF values and ACF changes can be logged to Sheets, all from FlowMattic on the site that holds the fields.

Bulk updates without per-task fees

Unlimited runs mean a nightly sync of hundreds of rows costs the same as one edit, and it all runs on your own server.

Common questions

How do I update ACF fields from Google Sheets?

Keep the post ID in a column, start a workflow with the Google Sheets Update Specific Column Value trigger on the column you edit, and add ACF Update Post Value with the post ID, field name and new value.

Can I export ACF field values to Google Sheets?

Yes. Use User Updates Post Field to write each change as a row. For existing posts, a Schedule with Get Post Value inside a loop can write the current values once.

Does this work with ACF options pages?

Yes. Update Option Value writes to an options page field, and User Updates Options Page Field starts a workflow when someone changes one in wp-admin.

Can I update custom fields on users?

Yes. Update User Value sets a field on a user by ID, and User Updates Profile Field starts a workflow when a profile field changes, for example to keep a member directory sheet current.

Will the free version of ACF work?

Yes, for text, number, date and select fields. Repeater, Flexible Content and options pages are ACF PRO features, so the steps that use them need PRO.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Advanced Custom Fields and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Advanced Custom Fields integration 1.1.1, Google Sheets integration 2.2.4.