• Skip to primary navigation
  • Skip to main content
  • Skip to footer
My Project Solution

My Project Solution

Web Design Greenville, SC, Shopify E-commerce & WordPress Website Development

  • Home
  • Services
    • Website Development
    • No-Code Solutions
    • WordPress Website Rescue
    • E-Commerce Development
    • E-Commerce Consulting
    • Hosting
    • Digital Marketing
  • Our Work
  • Request A Quote
  • Blog
  • Contact
  • Email

Google Forms, Google Sheets, SuperMetrics, and Monday.com

This project was completed for a marketing company. The client specializes in Facebook Ads for real-estate agents. The client uses Monday.com for various purposes, one being as a lite weight CRM for their reps. My Project Solutions was asked to automate manual processes for new client prospects and existing customers.

The challenge

  1. Automate the creation of a record in a Monday.com board when a new lead Google Form was submitted
  2. Create custom SuperMetrics queries to pull Facebook Ad data
  3. Sync SuperMetrics data to Monday.com updating the clients CRM record

The Solution

My Project Solution setup a custom integration between Google Forms and Monday.com. Each new Google Form submission creates a new contact record in a custom Monday.com CRM board. After the new contact record is created, a new record is created in a Google Sheet. SuperMetrics is used to pull Facebook Ads data for each Google Sheet record. When each row is updated in the Google Sheet, the updated Facebook Ads data is synced to Monday.com, updating the contact records.

My Project Solution leveraged Integromat to write the custom workflows and integrations.

 

« River Walk Recreation Association
Email to HubSpot »
Web Hosting by My Project Solution

Let’s work together

Get in touch with us and send some basic info about your project.

Request A Quote

Footer

Integromat Registered Partner
My Project Solution BBB Business Review

Contact

Get directions
(864) 757-2024
info@myprojectsolution.net
Mo,Tu,We,Th,Fr 8:30 am – 5:30 pm

Navigation

  • Home
  • Services
    • Website Development
    • No-Code Solutions
    • WordPress Website Rescue
    • E-Commerce Development
    • E-Commerce Consulting
    • Hosting
    • Digital Marketing
  • Our Work
  • Request A Quote
  • Blog
  • Contact

© 2022 My Project Solution | Terms | Privacy