I have attached my research on utilizing AI with Google Sheets. I explored ways to manipulate data intake to create an impactful tool with hundreds of potential use cases for open-source research.

This tool integrates multiple technologies, including:

  • API Connection: Leverages Perplexity AI’s "Sonar" & or "Sonar-Pro" model for intelligent data retrieval.
  • Google Apps Script: Automates background processes within Google Sheets, enabling Perplexity API prompt requests.
  • XML Data Extraction: Pulls image URLs directly from Google into Sheets and uses formulas to dynamically display images.
  • Dynamic URL Manipulation: Adjusts URLs based on user input, creating customized research pathways.
  • AI-Driven Refinements: Further enhances URL modifications based on Perplexity AI results or formula-driven clickable links to streamline research.
  • AI Prompt Stacking: This method allows results received from Perplexity to automatically generate additional prompts based on previous answers, enabling a single search value to stack, expand, and branch out research at scale.

By combining these elements, this tool offers a highly adaptable solution for various applications in open-source intelligence (OSINT), data analysis, and AI-powered research.

Workflow Diagram