Skip to main content
Best answer

Google Sheets to WordPress via lookup

  • October 25, 2022
  • 1 reply
  • 78 views

I think Zapier can help me solve a problem, but I'm not sure what the solution would be. I have a WordPress website and I want to lookup a value on a Google Sheet and show it on the WP page. Eg. I have a google sheet with a column for email address and another for promo code. I put a text box on the Shopify website that allows the customer to input an email address. If they input an email address in the Email column of the Google sheet, I want to output the Promo Code from the Google Sheet on the WP page.

Does anyone know if this is possible with Zapier?

Best answer by Troy Tessalone

Hi @Jay9933 

Good question.

To clarify, that would involve front-end scripting. (e.g. JavaScript)

Zaps are back-end (app to app) automations.

 

If you were to email the promo code, then you could Zaps.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • October 25, 2022

Hi @Jay9933 

Good question.

To clarify, that would involve front-end scripting. (e.g. JavaScript)

Zaps are back-end (app to app) automations.

 

If you were to email the promo code, then you could Zaps.