{"version":"1.0","provider_name":"LeadsHook Knowledge Base","provider_url":"https:\/\/www.leadshook.com\/help","author_name":"Nik T","author_url":"https:\/\/www.leadshook.com\/help\/author\/nik\/","title":"Using Google Sheets as a Lookup Table - LeadsHook Knowledge Base","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"024PzIFh91\"><a href=\"https:\/\/www.leadshook.com\/help\/using-google-sheets-as-a-lookup-table\/\">Using Google Sheets as a Lookup Table<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.leadshook.com\/help\/using-google-sheets-as-a-lookup-table\/embed\/#?secret=024PzIFh91\" width=\"600\" height=\"338\" title=\"&#8220;Using Google Sheets as a Lookup Table&#8221; &#8212; LeadsHook Knowledge Base\" data-secret=\"024PzIFh91\" 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":"Introduction In this article you&#8217;ll learn how to use Google Sheets as an external database. You can make API calls from LeadsHook using the API node and SAVE the returning data into custom fields. There are 2 methods available&#8230; METHOD 1: Easy Method Using a 3rd Party App (Developer NOT Required) In method 1, you [&hellip;]"}