Connect Microsoft 365 Excel and Perplexity AI integrations
Transform your Microsoft 365 Excel spreadsheets into intelligent, self-updating research hubs by automatically sending queries to Perplexity AI whenever new data appears. Watch as AI-powered insights flow back into your tables, connecting your everyday spreadsheet work with cutting-edge artificial intelligence that thinks, researches, and responds for you.
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.
Creates a chat completions with the chosen model.
Performs an arbitrary authorized API call.
Returns the ranked search results from Perplexity's continously refreshed index.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your Microsoft 365 Excel and Perplexity AI integrations.
Perplexity AI functions as a trigger that monitors your spreadsheets for changes or new data entries, automatically initiating workflows when specified conditions are met. When triggered, the integration sends queries from your Excel spreadsheets to Microsoft 365 Excel, which functions as an action by processing these queries and generating intelligent responses. Microsoft 365 Excel retrieves AI-powered research results and returns them to populate your Excel data tables with insights, completing the automated workflow between your spreadsheet management system and advanced AI capabilities.
Adds a new table.
Adds a new table column.
Adds a new table row.
Adds a new worksheet to a workbook.
Adds a new worksheet row.
Creates a chat completions with the chosen model.
Deletes a table.
Deletes a worksheet row.
Downloads the content of a specified Excel workbook.
Popular Microsoft 365 Excel and Perplexity AI workflows.
Looking to get more out of Microsoft 365 Excel and Perplexity AI? With Make you can visually integrate Microsoft 365 Excel and Perplexity AI into any workflow to save time and resources — no coding required. Try any of these templates in just a few clicks.
How to setup Microsoft 365 Excel and Perplexity AI in 5 easy steps
Add your app module to Make
Log into your Make account and open your scenario workspace. Find the Microsoft 365 Excel or Perplexity AI module you want to use and add it to your scenario. You'll see a Connection field appear in the module where you can link your app to Make.
Start creating your connection
Look for the 'Add' or 'Create a connection' button next to the Connection field in your module. Click this button to open a form where you'll enter the information needed to connect Make with your chosen application. You can optionally give your connection a memorable name to help identify it later.
Get your Perplexity AI access key
If you're connecting Perplexity AI, you'll need an API key from your Perplexity account. Go to Settings in your Perplexity AI account, click on API in the sidebar, and create a new API group. Navigate to the API Keys tab and click 'Create Key' to generate your unique access key.
Enter your credentials in Make
Copy your API key from Perplexity AI and paste it into the API Key field in Make's connection form. Make sure there are no extra spaces before or after the key. If you're connecting Microsoft 365 Excel, you'll be prompted to log into your Microsoft account to grant Make permission to access your files.
Save and confirm your connection
Click the Save button to establish your connection. Make will verify that your credentials are correct and confirm when the connection is successful. Your new connection will now appear in the dropdown menu, and you're ready to start building your automation using the connected app.
Automate Excel with AI-powered research and data enrichment
Connect Microsoft 365 Excel and Perplexity AI to automate research, enrich data, and generate intelligent reports. Eliminate manual entry while keeping spreadsheets updated with AI-powered insights.
Automatically populate Excel spreadsheets with AI-researched data from Perplexity, eliminating manual data entry and research time.
Enrich existing Excel data rows with contextual information and insights retrieved through Perplexity's AI-powered knowledge discovery.
Trigger Perplexity AI queries based on new Excel entries to keep your spreadsheets updated with the latest relevant information automatically.
Generate comprehensive Excel reports by combining your structured data with AI-generated summaries and research from Perplexity.
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 350,000+ customers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
Head of Operations at Teleclinic
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
COO at Shop Accelerator Martech
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
Product Owner at Smaily
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."
CTO & Co-founder at FINN
"I can't count the number of hours I've saved by using Make. Every single day is simpler because of Make's automation."
Owner of Media Production