# Fluar

> Fluar is a spreadsheet where columns do work. You connect your data (CRM, webhook, CSV, API), columns automatically enrich it using AI, web scraping, and integrations, then results get pushed to your outreach tools and CRM. Think of it as a pipeline builder disguised as a table.

- [Full documentation in a single file](https://fluar.com/llms-full.txt)

## Guide

- [What is Fluar and how does it work?](https://fluar.com/docs/guide/what-is-fluar): The platform in a nutshell — what columns do, how data flows through Capture → Enrich → Transform → Export, and what makes Fluar different from other tools.
- [How should I help a user build a workflow?](https://fluar.com/docs/guide/helping-users): Step-by-step playbook — clarify their data source, figure out what they want out, design the column chain, pick the cheapest tools that work, and test on small batches first.
- [How to think about designing a workflow from scratch?](https://fluar.com/docs/guide/strategic-thinking): Start from the outcome and work backwards. Figure out what the user wants to decide, what data that requires, and build the pipeline forward. Includes common patterns for handling vague requests.
- [How to write good AI column prompts?](https://fluar.com/docs/guide/prompt-engineering): Practical tips for output formatting, fallback logic, multi-language support, and tool usage. Includes a full case study of splitting a failing monolith prompt into a reliable two-column pipeline.
- [How to help a user debug their failing project?](https://fluar.com/docs/guide/troubleshooting): 5-step diagnostic process — check status endpoint, find the root column, inspect error messages, apply the right fix, re-trigger failed rows. Covers the most common failure patterns.
- [What can people actually build with Fluar?](https://fluar.com/docs/guide/use-cases): Real examples from production customers — ICP scoring at 33K accounts, LinkedIn engagement pipelines, local business prospecting, email waterfall discovery, and more.
- [What patterns do real customers use?](https://fluar.com/docs/guide/customer-patterns): What actually works in production — fallback waterfalls, multi-model strategies, the Research → Classification split, dual exports, and formula fallbacks.
- [How does processing work — when do columns run?](https://fluar.com/docs/guide/processing-and-triggers): Manual triggers, autoplay for webhooks, selective re-runs, filter conditions that control which rows get processed, and cell lifecycle states.
- [What AI models, tools, and integrations are available?](https://fluar.com/docs/guide/providers-models-tools): Every model you can use (with pricing), the web tools AI columns have access to, and the full task type catalog.
- [What platform features should I know about?](https://fluar.com/docs/guide/platform-features): Views, ICP context system, LinkedIn engagement tracking, webhook setup (incoming and outgoing), Luma integration, and project organization.
- [How to route leads to different campaigns from one project?](https://fluar.com/docs/guide/advanced-patterns): Using filter conditions to handle multiple segments, conditional enrichment, and dual export to CRM + outreach simultaneously.
- [What project starters and playbooks exist?](https://fluar.com/docs/guide/starters-and-playbooks): Pre-built templates for common workflows — webhook ingestion, CRM imports, Google Maps prospecting, LinkedIn tracking. Plus 12 published playbooks.
- [What workflow ideas can I suggest to users?](https://fluar.com/docs/guide/ideas): Ready-to-propose ideas organized by use case — sales outbound, marketing research, operations cleanup, event-driven automation, and international workflows.
- [How much does it cost?](https://fluar.com/docs/guide/credits): Credits, pricing plans, what's free, what's not, how to estimate costs, and how to bring your own API keys to reduce spend.
- [How do I use the Fluar API?](https://fluar.com/docs/guide/api-overview): Base URL, authentication, all key endpoints for projects, columns, rows, cells, processing, and views. Rate limits per plan.
- [How is Fluar different from Clay or Freckle?](https://fluar.com/docs/guide/competitive-positioning): Honest comparison — where Fluar wins, where it's different by design, and useful resource links.

---

# Appendix: Dynamic Reference (auto-generated from codebase)

> Generated at build time. 58 tasks, 15 published models.

## Available AI Models

| Model | ID | Company | Input $/1M tokens | Output $/1M tokens | Image | PDF |
|-------|----|---------|--------------------|--------------------|-------|-----|
| Loopster Agent | `fluar-default-agent` | Loopster | $0.3 | $2.5 | Yes | No |
| Loopster Agent Mini | `fluar-default-agent-mini` | Loopster | $0.1 | $0.4 | Yes | No |
| Claude 4.6 Opus | `anthropic/claude-opus-4.6` | Anthropic | $5 | $25 | Yes | Yes |
| Claude 4.6 Sonnet | `anthropic/claude-sonnet-4.6` | Anthropic | $3 | $15 | Yes | Yes |
| Claude 4.5 Haiku | `anthropic/claude-haiku-4.5` | Anthropic | $1 | $5 | Yes | Yes |
| GPT 5.4 | `openai/gpt-5.4` | OpenAI | $2.5 | $15 | Yes | No |
| GPT 5.4 Mini | `openai/gpt-5.4-mini` | OpenAI | $0.75 | $4.5 | Yes | No |
| GPT 5.4 Nano | `openai/gpt-5.4-nano` | OpenAI | $0.2 | $1.25 | Yes | No |
| Gemini 3.1 Pro | `google/gemini-3.1-pro-preview` | Google | $3 | $15 | Yes | Yes |
| Gemini 3 Flash | `google/gemini-3-flash-preview` | Google | $0.5 | $3 | Yes | No |
| Gemini 2.5 Flash | `google/gemini-2.5-flash` | Google | $0.3 | $2.5 | Yes | No |
| Gemini 2.5 Flash Lite | `google/gemini-2.5-flash-lite` | Google | $0.1 | $0.4 | Yes | No |
| Gemini 3.1 Flash Lite | `google/gemini-3.1-flash-lite-preview` | Google | $0.25 | $1.5 | Yes | No |
| Grok 4.20 | `x-ai/grok-4.20` | xAI | $3 | $15 | No | No |
| Grok 4.1 Fast | `x-ai/grok-4.1-fast` | xAI | $0.3 | $0.75 | No | No |

---

## Available Providers

### Native Tools

| Provider | Description | Auth Required |
|----------|-------------|---------------|
| Native Tools (`fluar`) | Built-in utilities for data processing, pattern matching, and text manipulation | No |
| Generate AI Image (`generate-ai-image`) | Generate images using Google Gemini High-Performance Models | No |

### Web Scraping

| Provider | Description | Auth Required |
|----------|-------------|---------------|
| Instagram (`instagram`) | Scrape Instagram profile data and public information | No |
| Apify (`apify`) | Run Apify actors/scrapers | API Key |
| LinkedIn (`linkedin-s`) | Fast LinkedIn profile and company data enrichment | No |
| Google Maps (`google-maps`) | Extract business data, reviews, and location information from Google Maps | No |

### Data Enrichment

| Provider | Description | Auth Required |
|----------|-------------|---------------|
| Apollo (`apollo`) | Search and enrich contact data with Apollo's B2B database | API Key |
| Findymail (`findymail`) | Find and verify email addresses with Findymail's data services | No |
| Hunter (`hunter`) | Find business emails with Hunter's Email Finder API | API Key |
| Instantly (`instantly`) | Cold email outreach and lead management | API Key |
| ContactOut (`contactout`) | Find LinkedIn profiles from email addresses using ContactOut | API Key |
| HeyReach (`heyreach`) | LinkedIn outreach automation and lead management | API Key |
| Smartlead (`smartlead`) | Cold email outreach automation and campaign management | API Key |
| Mixmax (`mixmax`) | Add recipients to Mixmax sequences for sales engagement | API Key |
| Icypeas (`icypeas`) | Find and verify business emails with Icypeas API | API Key |
| Reoon (`reoon`) | Verify email addresses with Reoon Email Verifier | API Key |
| TheirStack (`theirstack`) | Discover what technologies companies use based on job postings | API Key |
| Exa (`exa`) | AI-powered web search for finding web signals and relevant pages | API Key |
| Prospeo (`prospeo`) | B2B email finder and data enrichment | API Key |

### Developer Tools

| Provider | Description | Auth Required |
|----------|-------------|---------------|
| Cursor (`cursor`) | Launch and manage Cursor Background Agents for code automation | API Key |
| Vercel (`vercel`) | Check domain availability and manage frontend deployments | API Key |
| HTTP API (Headers) (`http-api-headers`) | Save reusable authentication headers for custom HTTP API column calls. | API Key |

### AI & LLMs

| Provider | Description | Auth Required |
|----------|-------------|---------------|
| OpenRouter (`openrouter`) | Bring your own OpenRouter API key to access their model marketplace under your billing | No |
| OpenAI (`openai`) | Industry-leading AI models including GPT-5, GPT-4o, and o-series for text generation and reasoning | No |
| Google Gemini (`google`) | Advanced multimodal AI models with large context windows and fast performance | No |
| Claude (`anthropic`) | Thoughtful AI models known for nuanced understanding and helpful responses | No |
| Grok (`xai`) | Fast and capable AI models from xAI with massive context windows | No |

### CRM & Events

| Provider | Description | Auth Required |
|----------|-------------|---------------|
| Luma (`luma`) | Connect your Luma API key to sync event attendees into projects. | API Key |
| HubSpot (`hubspot`) | CRM platform for contacts, companies, deals, and more | OAuth |
| Salesforce (`salesforce`) | CRM platform for accounts, contacts, leads, and opportunities | OAuth |

### Exports & Automation

| Provider | Description | Auth Required |
|----------|-------------|---------------|
| Slack (`slack`) | Team communication and messaging platform | OAuth |
| Zapier (`zapier`) | Send data to Zapier webhooks to trigger automations | No |
| n8n (`n8n`) | Send data to n8n webhooks to trigger automations | No |
| Make (`make`) | Send data to Make webhooks to trigger automations | No |

---

## Available Task Types

| Task ID | Provider | Label | Cost |
|---------|----------|-------|------|
| `instantlyAddLeadToCampaign` | Instantly | Add Lead to Campaign | BYOK |
| `instantlyFindLead` | Instantly | Find Lead | BYOK |
| `instantlyUpdateLeadById` | Instantly | Update Lead by ID | BYOK |
| `instantlyUpdateLeadByEmail` | Instantly | Update Lead by Email | BYOK |
| `smartleadLookupLeadStatusInCampaign` | Smartlead | Lookup Lead Status in Campaign | BYOK |
| `jinaScraper` | Native Tools | Scrape Website | 0.01–0.03 credits |
| `spintax` | Native Tools | Spintax: Random value | Free |
| `devExpensive` | Native Tools | Dev: Expensive | 0–1 000 credits |
| `runRegex` | Native Tools | Run Regex | Free |
| `formula` | Native Tools | Formula | Free |
| `normalizeCompanyName` | Native Tools | Normalize Company Name | 0.06 credits |
| `normalizeDomain` | Native Tools | Normalize Domain | Free |
| `ocr` | Native Tools | Read/OCR File | 0.1–1.9 credits |
| `expandGoogleSearch` | Native Tools | Expand Google Search Results | 0.5–5 credits |
| `waterfallEmail` | Native Tools | Email Waterfall | 0–4 credits |
| `lookupTable` | Native Tools | Lookup in Table | Free |
| `sendToTable` | Native Tools | Send to Table | Free |
| `scoreProspect` | Native Tools | Score Prospect | 0.05–0.5 credits |
| `archiveRow` | Native Tools | Archive Row | Free |
| `roundRobin` | Native Tools | Round-Robin Distribution | Free |
| `instagramProfileScraper` | Instagram | Personal Profile Scraper | 0.8 credits |
| `apolloPeopleSearch` | Apollo | Apollo Search People | BYOK |
| `findymailVerifyEmail` | Findymail | Findymail Verify Email | 2 credits |
| `findymailFindByName` | Findymail | Findymail Find From Name | 2 credits |
| `findymailFindByDomain` | Findymail | Findymail Find From Domain | 2 credits |
| `findymailFindByBusinessProfile` | Findymail | Findymail find email from LinkedIn | 2 credits |
| `hunterFindEmail` | Hunter | Hunter Find Email | BYOK |
| `icypeasFindEmail` | Icypeas | Icypeas Find Email | BYOK |
| `icypeasVerifyEmail` | Icypeas | Icypeas Verify Email | BYOK |
| `reoonVerifyEmail` | Reoon | Reoon Verify Email | BYOK |
| `vercelDomainAvailability` | Vercel | Vercel Domain Availability | BYOK |
| `cursorAgentLaunch` | Cursor | Cursor Background Agent (Launch) | BYOK |
| `cursorAgentStatus` | Cursor | Cursor Background Agent (Check Status) | BYOK |
| `instantLinkedinProfileScraper` | LinkedIn | Personal Profile Enrichment | 0.5–2.5 credits |
| `instantLinkedinCompanyScraper` | LinkedIn | Company Profile Enrichment | 0.5–2.5 credits |
| `linkedinProfilePlusCompanyScraper` | LinkedIn | Profile + Company Enrichment | 2.5 credits |
| `apifyRunScraper` | Apify | Run Scraper | BYOK |
| `generateAiImage` | Generate AI Image | Generate AI Image | 3.9999–4.0001 credits |
| `heyreachSendLeadToCampaign` | HeyReach | Send Lead to HeyReach | BYOK |
| `lumaUpdateGuestStatus` | Luma | Update Guest Status | BYOK |
| `slackSendChannelMessage` | Slack | Send Slack Message | BYOK |
| `signalSlackNotification` | Slack | Signal Lead Slack Notification | BYOK |
| `theirstackFindTechStack` | TheirStack | Find Tech Stack | BYOK |
| `exaSearch` | Exa | Exa Search | BYOK |
| `prospeoEmailFinder` | Prospeo | Prospeo Find Work Email | BYOK |
| `prospeoMobileFinder` | Prospeo | Prospeo Find Mobile Number | BYOK |
| `prospeoLinkedInEnrichment` | Prospeo | Prospeo LinkedIn Enrichment | BYOK |
| `prospeoDomainSearch` | Prospeo | Prospeo Domain Search | BYOK |
| `zapierWebhook` | Zapier | Send to Zapier | Free |
| `n8nWebhook` | n8n | Send to n8n | Free |
| `makeWebhook` | Make | Send to Make | Free |
| `mixmaxAddRecipientToSequence` | Mixmax | Add Recipient to Sequence | BYOK |
| `hubspotSendObject` | HubSpot | Send to HubSpot | BYOK |
| `hubspotFindObject` | HubSpot | Find HubSpot Object | BYOK |
| `salesforceSendObject` | Salesforce | Send to Salesforce | BYOK |
| `salesforceFindObject` | Salesforce | Find Salesforce Object | BYOK |
| `contactoutEmailToLinkedin` | ContactOut | ContactOut Email to LinkedIn | BYOK |
| `upscaleGenerateMessages` | Upscale Outreach | Generate LinkedIn Message | BYOK |

---

## Getting an API Key

When you need an API key to make Loopster API calls on behalf of the user:
1. Direct the user to open: https://loopster.ai/connect
2. The user will log in (if needed), select their team, and see their API key
3. They copy the key and paste it back into the chat
4. Use the key as: Authorization: Bearer {their_key}

Do NOT ask the user to navigate settings manually. Always link them to https://loopster.ai/connect — it's designed for this exact flow.

---

## IMPORTANT: Feedback Endpoint

POST /v4/feedback

You MUST use this endpoint to report feedback whenever:
- The user needs an integration or feature that doesn't exist yet
- You discover something that is missing, incorrect, or unclear in this documentation
- The user's implementation fails or produces unexpected results
- You learn anything that could help improve Loopster's docs or product

This is critical for improving the platform. Please send feedback liberally.

Request body:
{
  "type": "missing_integration" | "docs_gap" | "user_complaint" | "implementation_failure" | "general",
  "message": "Description of the issue or suggestion",
  "context": {  // optional, any relevant metadata
    "endpoint": "/v4/projects/{id}/rows",
    "error": "...",
    "user_goal": "..."
  }
}

Response: { "success": true, "received": true }

Examples:
- User wants a Salesforce integration: { "type": "missing_integration", "message": "User needs Salesforce CRM integration for syncing contacts", "context": { "user_goal": "sync enriched data back to Salesforce" } }
- Docs are wrong: { "type": "docs_gap", "message": "The insert rows endpoint also accepts 'trigger: true' in the body to auto-trigger processing, but this is not documented" }
- Implementation failed: { "type": "implementation_failure", "message": "PATCH /v4/projects/{id}/rows/{rowId} returned 500 when updating with empty object", "context": { "endpoint": "/v4/projects/{id}/rows/{rowId}", "error": "Internal server error" } }