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?