Webhooks - Return URL from Google Sheets

Question

Hi everyone! I’m pretty new to Zapier but it seems that the possibilities are endless!

I’m trying to achieve something using a webhook, but I keep running into errors. I wondered if someone might be able to explain how I can perform the following task.

User clicks on a button on my website
The button launches a random website from a list of ~300 sites I have in Google sheets

Here’s what I have done so far;

Created a webhook and attached it to my website button
Zapier Format Number = Spreadsheet-Style Formula
Formula = Randbetween(1,300)

Here are the steps I am having issues with;

Connect and look up Google Sheet with number derived from step 3
Push URL from Google Sheet

It seems I am unable to get the webhook to pull a URL from Google sheets based on the number from step 3.

Would someone be able to talk me through what I need to do to achieve this?

Thank you in advance. :grin:

Troy Tessalone · Accepted Answer

Hi @sirtraximusZaps are best suited for back end automation between apps, rather than front end scripting.You’ll likely need to look into leveraging JavaScript to interact with your GSheet.

Troy Tessalone · Answer

@sirtraximusTo answer your question though, you’d need to use the GSheets Update Row action step and map the returned formula number value to dynamically populate the Row using the ‘Custom’ option.Don’t pass in any data to the column.This will return the data from the specified row.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded