Google sheet is an go to tool to storing data into row and column for free with thousands of in-built funstions and addons. Access google sheet data with API and using into the projects.
Let’s take an example, you are building an marketplace website with google sheet API and wants to add advanced search option there. So, it’s now possible without any coding.
In this blog post, we are going to show you how you can sync your google sheet data into algolia and use the Algolia endpoint into your project for the Advanced search feature.
If you want to skip this blog then watch the YouTube video in action ↳ Sync Google Sheet Data to Algolia
There are three steps:
- Setup Google Sheet API
- Setup Algolia API
- Use Integromat to automate
Setup Google Sheet API
Login to NoCodeAPI, find the Google Sheet into the Marketplace and activate this. You will see a page to set up Google Sheet API endpoints. Click on Make Google Sheets API
To set up Google Sheet API you have to Authenticate with your google account and have to input your spreadsheet ID. You can watch the video below ↓
Schedule the scenario
So, you can run this scenario at a regular interval. Like you can do every 1 hour, every day, day of the week, or custom date.
Click on the timer icon on the starting module.
https://v1.nocodeapi.com/<username>/algolia/<token>/index?indexName=<indexName>&type=replace
