Supabase allows large datasets and can perform very fast lookup via their built-in API tools. Step 1: Set up your Supabase project Step 2: Upload your CSV Step 3: Find the API details and request URL Sample Request URL:https://<your_project_id>.supabase.co/rest/v1/<table_name>?<table_column>=eq.{zip} Headers: Short video of setting it up: How to setup autocomplete lookup to your Supabase database […]
Articles Tagged: database
How to use Google Sheet as a lookup table
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 […]
Using Google Sheets as a Lookup Table
Introduction In this article you’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… METHOD 1: Easy Method Using a 3rd Party App (Developer NOT Required) In method 1, you […]
