Create a CRUD REST API with Google Sheets database

Simple REST API with Google Sheets

Introduction

This workflow template demonstrates how to quickly and easily create a simple REST API using n8n and a Google Sheet as a no-code database. It's a perfect starting point for building a backend for small applications, prototypes, or internal tools without writing any code.

Purpose

The purpose of this template is to provide a complete, ready-to-use n8n workflow that handles all fundamental CRUD (Create, Read, Update, Delete) operations. The workflow uses a single Webhook trigger to handle POST, GET, PUT, and DELETE requests, allowing you to manage data in your Google Sheet through standard API calls.

Setup Instructions

To get started with this template, follow these steps:

1. Prepare your Google Sheet: Create a new Google Sheet and add the following column headers in the first row: name, email, and status. You can use this [example Google Sheet](https://docs.google.com/spreadsheets/d/1bQyl8pGVutkq1LRwK-6TAAcXwNj4TipeWHi-qmK1Q/edit?usp=sharing) as a starting point. This sheet will serve as your database. 2. Authenticate: In the n8n workflow, connect your Google Account credentials to the Google Sheets nodes. 3. Select your data: Choose the Google Sheet and the corresponding sheet name from the drop-down lists in each of the Google Sheets nodes. 4. Activate: Save and activate the workflow. 5. Test the API: Use a tool like curl, Postman, or Insomnia to test your new API endpoints. The base URL will be your n8n webhook URL followed by /items.