The Ask Perplexity AI enrichment helps you run Perplexity prompts on spreadsheet data in bulk.

You can use fields from each row as variables, then let Datablist manage the execution flow.

This is a practical way to automate text analysis, cleanup, and AI-assisted workflows without building custom scripts.

Why use Perplexity inside Datablist?

Perplexity is useful when you want a model-driven workflow tied to row-level data.

Datablist adds the spreadsheet layer around it:

  • Prompt variables from your columns
  • Batch execution
  • Retry handling
  • Output mapping
  • Optional structured outputs

You keep the flexibility of prompt-based work without running custom code.

Why use Datablist to run Perplexity in bulk?

Datablist makes Perplexity practical for CSV and Excel workflows.

  • No collection record limit: Process a short list or a large CSV file from the same Datablist collection.
  • Use your own API key: Connect your Perplexity API key and pay Perplexity directly for model usage.
  • Retries and throttling: Datablist manages API throttling and retries failed requests.
  • Status for each row: Every item has a processing status. Filter failed rows, fix the prompt or data, and retry only those records.
  • Structured outputs: Define multiple output fields and store each Perplexity response field in its own column.

Step-by-step guide

Step 1: Import your spreadsheet

Upload your CSV or Excel file into Datablist.

Step 2: Select "Ask Perplexity AI"

Open Enrich and choose the enrichment.

Step 3: Add your API key, build the prompt, and run

Connect your Perplexity API key, write the prompt with row variables, choose the output fields, and run a preview before processing the full list.

The default Perplexity model in the enrichment is Sonar, with support for Sonar Pro as well.

Good fits

  • Analyze or rewrite text in large CSV files
  • Build repeatable AI workflows from spreadsheet data
  • Automate research-style prompts on many rows
  • Extract structured answers from semi-structured text

Pricing

Datablist does not charge for this enrichment, but it requires a Perplexity API key.

You pay Perplexity directly for model usage.

FAQ

Can I run Perplexity on a large CSV?

Yes. Datablist is built for large CSV and Excel files. You can run Perplexity prompts on large collections without splitting your data.

What happens when a Perplexity request fails?

Datablist stores the status for each row. You can filter rows with errors and retry only those records.

Can Perplexity fill multiple columns?

Yes. Use structured outputs to return several fields from one prompt, then map each field to a Datablist column.