Using a Google Sheet for CRM Integrations

Posted by: Melissa Hostetter Date Posted: May 11, 2023
Back to Case Studies

Issue

Their custom CRM didn’t have a way for us to set up a custom integration via Workato.

Solution

We used a Shared Google Sheet with the following columns to map the integration back to MCFX:

  1. Contact Name (First/Last)
  2. Company Name (optional – if business is B2B)
  3. Email
  4. Phone Number
  5. Contact Stage (disqualified, qualified (SQL), customer or lost)
  6. Deal ID (needs to be unique to that opportunity)
  7. Deal Status (open, closed won or closed lost)
  8. Value (for Revenue)
  9. Date Opened
  10. Date Closed
  11. Last Updated Date

We will then use Contact Stage to also enter Lead Quality:

  1. Disqualified = Thumbs Down/Poor Rank
  2. SQL, Customer or Lost = Thumbs Up/Good Rank

Additional Resource on G-Sheet Integrations: https://app.getguru.com/card/cy4K8Ryi/IntegrationsFX-Google-Sheets

Achievement

We were able to get CRM data from Barefoot’s sales team (even though their Industry-specific CRM didn’t have an open webhook/API) by using a Google Sheet.

Now this client can see what channels are driving the best ROI and power LQB pipelines!

Snippet/Screenshot/Link

Screenshot of G-Sheet Data: https://webpagefx.mangoapps.com/msc/MTIxNTQ5N18xMTQ4NTM0OA