Building Better Lead Workflows

Introduction

Supabase is an open-source Firebase alternative. It's a great tool for building a backend for your app. PIKIEE uses structured workflows to keep lead research and scoring organized.

1. Create a supabase account

First, go to Supabase and create an account. It's free for up to 10,000 rows per table.
Then create a new project and a new table. You can use the following SQL schema:

CREATE TABLE public.users (
  id bigint NOT NULL DEFAULT nextval('users_id_seq'::regclass),
  email text NOT NULL,
  password text NOT NULL,
  created_at timestamp with time zone NOT NULL DEFAULT now(),
  updated_at timestamp with time zone NOT NULL DEFAULT now(),
  CONSTRAINT users_pkey PRIMARY KEY (id)
);

2. Add your credentials to PIKIEE

Copy the API URL and API Key from your Supabase project settings and add them to your PIKIEE project settings. Add these files to your project:

• .env.local
• .env.production