Pica Logo

Pica Assistant

Your integration companion

Pica Logo

Welcome to Pica! ✨

I'm here to help you discover how Pica can transform your workflow with powerful integrations.

Popular questions

Hover to see more

+7 more questions

Bolt LogoΓ—Notion
Notion

Building a Waitlist Page Powered by Notion

Create a minimal waitlist signup page that saves entries directly to a Notion database using Bolt and Pica

November 28, 2024
Pica Team
notionwaitlistsignupbuildkit

In this guide, we'll build a waitlist signup page that saves entries directly to a Notion database. With Bolt and Pica, you can create a beautiful signup form in minutesβ€”using Notion as your backend database.

What You'll Build

By the end of this tutorial, you'll have:

  • A minimal, beautiful waitlist signup page
  • Form fields for name and email
  • Direct integration with your Notion database
  • Production-ready error handling

Let's get started! πŸš€

Step 1: Build the Waitlist UI

First, let's create a clean, minimal waitlist signup page.

Prompt Bolt:

"Build me a minimal waitlist signup page UI with fields for name and email address"

Bolt will generate a beautiful, responsive signup form with proper validation and styling.

Waitlist UI

Step 2: Create a Database in Notion

Now let's set up your Notion database to store waitlist entries.

Notion Database Setup

Creating Your Database:

  1. Go to Notion and create a new page
  2. Create a new database (table view works great)
  3. Add these columns:
    • Name (Title) - The person's name
    • Email (Email) - Their email address
Notion Database Setup

Step 3: Create a Notion Connection in Pica

You need to connect your Notion account to Pica so your waitlist form can add entries to your database.

Notion Connection

How to Connect Notion:

  1. Go to the Pica dashboard at: app.picaos.com/connections
  2. Click on + Add Connection
  3. Select Notion from the list of integrations
  4. Authenticate with your Notion account
  5. Grant access to your database when prompted
  6. Save your connection key - you'll need this later!

Step 4: Copy Your Notion Database ID

To add entries to your Notion database, you'll need to get the database ID.

How to Find Your Database ID:

  1. Open your Notion database page
  2. Copy the page URL from your browser
  3. The URL will look like this:
    https://www.notion.so/your-workspace/2b8d524b542c8097b454f66f14d8d630?v=...
    
  4. The database ID is the 32-character string before the ?v= parameter
    • Example: 2b8d524b542c8097b454f66f14d8d630

Keep this ID handy - you'll need it in the next step!


Step 5: Generate Your Code with BuildKit

Now we'll use Pica BuildKit to generate the perfect prompt for adding entries to your Notion database.

Using BuildKit:

  1. Go to the BuildKit page at: app.picaos.com/buildkit
  2. Type: "Retrieve the notion database [YOUR_NOTION_DATABASE_ID] and the data source id. Then I want to add pages into that datasource."
  3. BuildKit will generate an optimized prompt for you

Or copy the prompt here:

Important: Replace YOUR_NOTION_DATABASE_ID in the prompt with your actual database ID from Step 4.

What BuildKit Does:

BuildKit automatically generates a prompt that includes:

  • βœ… Proper API authentication setup
  • βœ… Database retrieval to get the data source ID
  • βœ… Page creation with custom properties
  • βœ… Error handling best practices
  • βœ… Environment variable configuration
  • βœ… Integration with your Pica Notion connection

πŸš€ Next step: Copy the prompt above and paste it into Bolt.new to create your backend logic!


Step 6: Add Your Secrets to Bolt

Once Bolt generates your application, you'll need to add your API keys as environment variables.

Add Secrets

Required Environment Variables:

1. PICA_SECRET_KEY

2. PICA_NOTION_CONNECTION_KEY

How to Add Secrets in Bolt:

  1. Click on the Settings icon in Bolt
  2. Navigate to Secrets
  3. Add both keys with their respective values
  4. Save and restart your application

Now your waitlist form is connected to Notion and will save entries directly to your database! πŸŽ‰


Step 7: Try It in Action

Test your waitlist by submitting a few entries. You should see them appear in your Notion database immediately!

Waitlist Demo

Troubleshooting

Form submissions not saving?

  1. Check your environment variables - Make sure both keys are set correctly in your Bolt secret settings
  2. Verify your Notion connection - Go to app.picaos.com/connections and ensure it's active
  3. Check database permissions - Make sure you granted Pica access to your specific database
  4. Verify the database ID - Ensure you're using the correct 32-character ID
  5. Check property names - Property names are case-sensitive (e.g., "Name", "Email")
  6. Check property types - Make sure "Email" is set as an Email type column in Notion
  7. Check Pica logs - View execution logs in your Pica dashboard

Conclusion

Congratulations! πŸŽ‰ You've just built a production-ready waitlist signup page powered by Notion in minutes. No complex database setup, no separate backend to manageβ€”just clean, working code with data you can view and manage from Notion.

You can now track your waitlist signups directly in Notion, sort and filter entries, and even add additional automation with Notion's built-in features!

Ready to add more integrations? Explore other Bolt use cases to supercharge your application with Pica.


Get Help

Questions or need support?

Happy building! πŸš€

Ready to build with Bolt?

Start creating AI-powered applications with seamless Notion integration today