{"version":"1.0","provider_name":"LeadsHook Knowledge Base","provider_url":"https:\/\/www.leadshook.com\/help","author_name":"Von","author_url":"https:\/\/www.leadshook.com\/help\/author\/voncs-leadshook-com\/","title":"How to use Google Sheet as a lookup table - LeadsHook Knowledge Base","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"xBIkoo7HCB\"><a href=\"https:\/\/www.leadshook.com\/help\/how-to-use-google-sheet-as-a-lookup-table\/\">How to use Google Sheet as a lookup table<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.leadshook.com\/help\/how-to-use-google-sheet-as-a-lookup-table\/embed\/#?secret=xBIkoo7HCB\" width=\"600\" height=\"338\" title=\"&#8220;How to use Google Sheet as a lookup table&#8221; &#8212; LeadsHook Knowledge Base\" data-secret=\"xBIkoo7HCB\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/www.leadshook.com\/help\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"Zipcode Lookup This method returns all row values associated with the zip code or any other data. It is useful for lookups when you need to retrieve the corresponding values. Step 1: Sign in to your Google account and access this google sheet link. https:\/\/docs.google.com\/spreadsheets\/d\/1e8hYcRYIsu0bHY-445NKVB58nFxhS0mB2C9LRriJ_ik\/edit?usp=sharing Step 2: Make a copy of the google sheet file [&hellip;]","thumbnail_url":"https:\/\/www.leadshook.com\/help\/wp-content\/uploads\/2025\/02\/Make-a-copy.png","thumbnail_width":658,"thumbnail_height":450}