# Connect Google Forms to Odoo and automate your tasks ## Why integrate Google Forms with Odoo The Google Forms to Odoo integration helps you sync data, automate manual tasks, and keep your stack aligned — without writing code. ### Turn Google Form responses into Shopify customer records automatically When someone completes a Google Form — an onboarding survey, a wholesale inquiry, a product quiz — MESA creates or updates their record in Shopify with the responses. Your store knows more about each customer before they place their next order without anyone transferring data between platforms manually. ### Trigger Shopify workflows from what customers tell you in a form When a Google Form response meets a condition — a product preference, a budget range, a custom order request — MESA kicks off the right workflow in Shopify. Your forms become the starting point for personalized automation, not just a data collection step that someone has to act on later. ### Route form submissions to the right team and tools automatically When a Google Form is submitted, MESA reads the responses and sends the details to the right place — a Slack message, a ClickUp task, an Airtable record. The right person gets the context they need without anyone triaging submissions from a shared inbox. ### Push every Shopify order into Odoo for back-office processing When an order is placed in Shopify, MESA sends it to Odoo with the relevant details — line items, customer record, payment status — already populated. Your ERP reflects every sale the moment it happens without a manual import step or a scheduled sync holding things back. ### Keep inventory accurate across Shopify and Odoo in real time When stock changes in Odoo — a production run completed, a purchase order received, a manual adjustment — MESA updates the corresponding Shopify product availability. Your storefront never oversells what your ERP knows isn't there. ### Sync Shopify customer records with Odoo's CRM and accounting modules When a new customer places their first Shopify order, MESA creates or updates their record in Odoo across the relevant modules — CRM, accounting, contacts. Your back-office always reflects the same customer your storefront sees without periodic reconciliation between systems. ## Build any Google Forms and Odoo automation MESA helps you connect apps to automate repetitive tasks. A trigger is an event that starts a workflow, and actions are the steps that occur when it's running. ###### Customer Created Starts when a customer is created - Is Follower - Followers - Followers (Partners) - Messages - Has Message - Action Needed - Number of Actions ###### Customer Updated Starts when a customer is updated - Is Follower - Followers - Followers (Partners) - Messages - Has Message - Action Needed - Number of Actions ###### Inventory Updated Starts when a product inventory is updated ###### Order Created Starts when an order is created - Campaign - Source - Medium - Activities - Activity State - Responsible User - Next Activity Type ###### Order Updated Starts when an order is updated - Campaign - Source - Medium - Activities - Activity State - Responsible User - Next Activity Type ###### Product Created Starts when a product is created - Activities - Activity State - Responsible User - Next Activity Type ###### Product Updated Starts when a product is updated - Activities - Activity State - Responsible User - Next Activity Type ###### Product Variant Created Starts when a product variant is created ###### Product Variant Updated Starts when a product variant is updated ###### Google Forms Submitted Starts when a Google Forms submission is received. ###### Convert Country & State to Odoo Ids Convert a county and state to the corresponding Odoo Ids - Country ID - State ID ###### Create Custom Model Create a custom model. - Custom Entity Name (e.g. 'res.country') ###### Create Customer Create a new customer record. ###### Create Order Create an order. ###### Create Order Line Create an order line. ###### Create Product Create a product. ###### Create Product Variant Create a product variant. ###### Delete Custom Model Remove a custom model. ###### Delete Customer Remove a customer record. ###### Delete Order Remove an order. ###### Delete Order Line Remove an order line. ###### Delete Product Remove a product. ###### Delete Product Variant Remove a product's variant. ###### List Custom Model Catalog all custom models. ###### List Customer Catalog all customer records. - Is Follower - Followers - Followers (Partners) ###### List Order Catalog all orders. - Campaign - Source - Medium - Activities - Activity State ###### List Order Lines Catalog all order lines. - Analytic Precision - Order Reference - Sequence - Company - Currency ###### List Product Catalog all products. - Activities - Activity State - Responsible User - Next Activity Type - Activity Type Icon ###### List Product Variant Catalog all product's variants. - Activities - Activity State - Responsible User - Next Activity Type - Activity Type Icon ###### Retrieve Custom Model Grab all details about the custom model. ###### Retrieve Customer Grab all details about the customer. - Is Follower - Followers - Followers (Partners) ###### Retrieve Order Grab all details about the order. - Campaign - Source - Medium - Activities - Activity State ###### Retrieve Order Line Grab all details about the order line. - Analytic Precision - Order Reference - Sequence - Company - Currency ###### Retrieve Product Grab all details about the product. - Activities - Activity State - Responsible User - Next Activity Type - Activity Type Icon ###### Retrieve Product Variant Grab all details about the product's variant. - Activities - Activity State - Responsible User ###### Update Custom Model Modify a custom model. ###### Update Customer Modify a customer's account details. ###### Update Order Modify an order's details. ###### Update Order Line Modify an order line. ###### Update Product Modify a product's details. ###### Update Product Variant Modify a product's variant.