I use Perplexity Pro subscription. I have tested a prompt to collect specific data about a company name and was satisfied with results. There is only one input field for the prompt on Perplexity website. I used “Sonar” model.
Then I used Zapier and Google sheets to process a list of the companies with the same prompt where the name of the company will change with each iteration. To clarify I used the same ‘user prompt” in Zapier interface and tried blank or trivial “system prompt”. I tried “sonar”, “sonar-reasoning” and “sonar pro” models.
The resulting output was much worse through Zapier. The sources (citations), that AI used, were not really relevant, while using Perplexity directly gave fewer but much more relevant sources. For example I asked whether the company uses specific technology and Perplexity searched for “<company name> <technology>” finding relevant web pages for citation. Inside Zapier the sources were just about the company. No surprise that it couldn’t answer about whether the technology is used.
So I wanted a simple thing: run Perplexity in a cycle with company name as a parameter. Then parse and save the results. Zapier helped with cycling, parsing and storing. But the perplexity step was bad quality. Inside perplexity website I have good AI quality, but cycling, parsing and storing must be done manually. So is there a way to combine both processes?




