Skip to main content

Make Waves ’26 Step into AI’s glass box. Prague, 19–20 Oct.

Register now (opens in a new tab)
Perplexity AI
Microsoft 365 Excel

Connect Perplexity AI and Microsoft 365 Excel integrations

Explore ready-made Perplexity AI and Microsoft 365 Excel templates and start automating in minutes.

Get started free

Create a custom workflow

Transform Perplexity AI research insights into organized Microsoft 365 Excel spreadsheets automatically through Make's powerful automation platform. Eliminate manual data entry and let AI-generated responses flow into structured Excel formats that update in the background, so you can focus on analysis instead of copying and pasting data.

Create a custom workflow

Every automation starts with a trigger and an action. Select one from each app to generate a workflow tailored to your needs.

Microsoft 365 Excel
Trigger: Watch Table Rows
Perplexity AI
Action: Select an action
1. Select a trigger

  • Triggers when a new row is added to a table.

  • Triggers when a workbook is created.

  • Triggers when a new row is added to a worksheet.

2. Select an action

  • Creates a chat completions with the chosen model.

  • Generate a response for the provided input with optional web search and reasoning.

  • Generate contextualized embeddings for document chunks. Chunks from the same document share context awareness, improving retrieval quality for document-based applications.

  • Generate vector representations (embeddings) for the text you provide.

  • Performs an arbitrary authorized API call.

Select a trigger and an action

Create workflow (opens in a new tab)

Triggers and actions

Connect Microsoft 365 Excel as a trigger and Perplexity AI as an action through Make's automation platform to automatically populate Excel sheets with research findings from Microsoft 365 Excel. When Microsoft 365 Excel generates insights or completes research queries, this trigger initiates automated workflows that capture AI-generated responses and transform them into structured Excel formats as an action. You can automatically populate Perplexity AI sheets with data from Microsoft 365 Excel, eliminating manual data entry while organizing AI responses into spreadsheets that run on autopilot in the background.

Add a Table
Adds a new table.
Action
Add a Table Column
Adds a new table column.
Action
Add a Table Row
Adds a new table row.
Action
Add a Worksheet
Adds a new worksheet to a workbook.
Action
Add a Worksheet Row
Adds a new worksheet row.
Action
Create a chat completion
Creates a chat completions with the chosen model.
Action
Create an agent response
Generate a response for the provided input with optional web search and reasoning.
Action
Delete a Table
Deletes a table.
Action
Delete a Worksheet Row
Deletes a worksheet row.
Action
Load more

How to set up Perplexity AI and Microsoft 365 Excel in 5 easy steps

Date

·

Duration

Step 1

Add your app module to Make

Log into your Make account and open your scenario. Select either the Microsoft Excel or Perplexity AI module from the available apps and add it to your workflow. You'll notice a connection field appear where you can set up the link between Make and your chosen application.

Date

·

Duration

Step 2

Start creating your connection

Look for the 'Add' button next to the Connection field for Microsoft Excel, or the 'Create a connection' button for Perplexity AI, and click it. A new window will open where you can enter the information needed to connect Make with your application. You can optionally give your connection a memorable name to help you identify it later.

Date

·

Duration

Step 3

Get your Perplexity AI API key

If you're connecting Perplexity AI, you'll need to obtain an API key from your Perplexity account. Go to your Perplexity AI settings, navigate to the API section, and generate a new API key. Copy this key carefully as you'll need to paste it into Make in the next step.

Date

·

Duration

Step 4

Complete the authentication process

For Perplexity AI, paste your API key into the designated field in the Make connection window. For Microsoft Excel, you'll be asked to log into your Microsoft account with your email and password. Both methods ensure secure communication between Make and your chosen application.

Date

·

Duration

Step 5

Save and verify your connection

Click the 'Save' button to store your connection details securely in Make. After confirming any permission requests that appear, your new connection will show up in the Connection dropdown menu of your module. You're now ready to build your automation and start using features like managing Excel spreadsheets or utilizing Perplexity AI's capabilities.

Automate research and data management with Perplexity AI and Microsoft 365 Excel

Connect Perplexity AI with Microsoft 365 Excel to automatically transfer research insights, update knowledge bases in real-time, and simplify report generation with improved data analysis workflows.

Date

·

Duration

Automated research data export

Automatically transfer research findings and AI-generated insights from Perplexity AI directly into Excel spreadsheets for organized analysis and reporting.

Date

·

Duration

Real-time knowledge base updates

Continuously populate Excel workbooks with the latest information discovered through Perplexity AI queries, keeping your data current without manual effort.

Date

·

Duration

Simplified report generation

Combine Perplexity AI's information discovery capabilities with Excel's data visualization tools to create comprehensive reports automatically.

Date

·

Duration

Better data analysis workflows

Enrich existing Excel datasets with relevant research and contextual information from Perplexity AI to make more informed business decisions.

Support

FAQs

Everything you need to know about Make. Can't find the answer you're looking for? Please chat to our team.

By connecting Perplexity AI with Microsoft 365 Excel through Make, you can automatically populate your spreadsheets with research findings and knowledge discovery results. For example, you can set up workflows that query Perplexity AI for specific information and automatically insert the results into designated Excel cells or rows. This eliminates manual copy-pasting, saves hours of research time, and ensures your Excel reports always contain the most current and comprehensive information available through Perplexity's AI-powered search capabilities.

There are numerous powerful use cases for this integration: automatically generating market research summaries in Excel spreadsheets, enriching customer data with AI-powered insights, creating competitive analysis reports by querying Perplexity and organizing results in Excel, updating product information sheets with the latest industry knowledge, and building automated fact-checking workflows for data validation. Make's visual automation platform allows you to create these workflows without coding, enabling you to trigger Perplexity queries based on new Excel entries or schedule regular research updates to keep your spreadsheets current.

Not at all! Make's intuitive drag-and-drop interface makes it straightforward to connect Perplexity AI and Microsoft 365 Excel, even without technical expertise. You select the triggers (like a new row in Excel) and actions (like querying Perplexity AI and writing results back to Excel), then configure the data flow between them. Make provides pre-built modules for both applications, templates to get started quickly, and detailed documentation to guide you through the process. Most users can create their first working automation in just minutes, and Make's visual workflow builder lets you see exactly how data moves between the applications.

Using Make to integrate Perplexity AI and Excel offers significant advantages over manual processes: it eliminates repetitive research tasks that could take hours daily, reduces human error in data transfer, ensures consistency in how information is gathered and organized, and scales as your needs grow. Make provides a no-code platform with robust error handling, scheduling capabilities, conditional logic, and the ability to connect with thousands of other apps. You can create sophisticated multi-step workflows that would require substantial development time and costs with traditional approaches, all while maintaining full control and flexibility to modify your automations as your business needs evolve.