What are you trying to achieve?
Hi everyone,
I’m new to make.com and I’m looking to automate a part of my workflow. Here’s what I want to achieve:
I have a Google Spreadsheet that contains a list of prompts.
I want these prompts to be sent to Perplexity (an AI-based tool).
I need the responses generated by Perplexity to be automatically collected and added back to the Google Spreadsheet.
Could anyone guide me on how to set this up using make.com? Any advice, tutorials, or examples would be greatly appreciated!
Thanks in advance for your help!
Best regards,
Ish
Hi ishtiaque,
It depends on how you have things set up within your google sheet, but here is a rough idea of how this could be done 
- Use the Google sheet “Get a cell” module. Your list of prompts will need to be in the same cell (For example A1) or you can use multiple of these “Get a cell” modules to collect information from multiple cells.
- Then you can use a perplexity module “Create a chat completion”. Within the message box you will want to map the value of the output of the google sheet “get a cell” module into the input for perplexity
- You can then use a google sheet “Update a cell” module to input the perplexity response back into the same (or different spreadhseet. Again you can just specificy the cells you want the result to be added to
The scenario ive described will look like this:
Hope this helps, any questions let me know
1 Like
