Has anyone found a solution to automatically update a user account access setting in Webflow based on manual verifications recorded in a Google Sheet? Thank you!

Automatically updating user access in Webflow using Google Sheets is not natively supported, but it can be achieved through third-party automation tools and custom logic. Here's how you can set up a semi-automated workflow.

1. Understand Webflow Membership Limitations

• Webflow Memberships (Beta/Available on Enterprise) allows managing user accounts and access groups, but it does not offer native API access for updating user roles or memberships dynamically.
• You cannot directly update Webflow user settings from Google Sheets without using an intermediate automation tool or workaround.

2. Use a Connector like Make or Zapier

• Use Make (formerly Integromat) or Zapier to watch for changes in a Google Sheet (e.g., when "verified = yes").
• Set up a scenario or Zap that triggers when row values change (e.g., using the "Update Row" or “New Value in Row” trigger).

3. Connect to a Backend Service

Since Webflow’s user access is restricted and cannot be updated directly via API:

• Use an authentication proxy, Firebase, or Airtable + Memberstack/Xano as an external user system.
• Store user access permissions there, control which Webflow content is shown with custom embeds or conditional visibility (via custom attributes or Memberstack).

4. Implement Client-Side Conditions in Webflow

• If you're using Memberstack or another membership tool to authenticate users in Webflow:
• Sync user metadata or tags with verification status pulled from your Google Sheet.
• Use custom attributes or embeds in Webflow to conditionally display/hide content based on user tags.

5. Example Workflow (Using Make + Memberstack + Webflow)

• Trigger: Change in Google Sheet row (e.g., "verified" becomes "yes").
• Action 1: Find the associated user in Memberstack.
• Action 2: Update a custom property (e.g., add the "verified" tag).
• Action 3 (optional): Trigger a Webflow CMS update or display logic change if needed.

Summary

Webflow alone cannot dynamically update user access from Google Sheets, but using Make or Zapier combined with a membership tool like Memberstack or Xano, you can create an automated workflow that updates user access based on Google Sheet verification.