I am creating a process where I can take a .csv file (thousands of lines of data) and run A.I. prompts on certain fields to analyze for a few things: Perspective, Sentiment, Summary, contact info.  If it can pull in websites to a new column that would be great.  If it can auto-download the referenced links that would also be helpful.  Some of the .csv. lines contain weblinks to documents that might need to be converted to text first.  

Workflow would be:
– Upload .csv to shared folder
– Automation that extracts relevant data (via Make.com) to database (okay with Google Sheets but interested in hearing if Airtable is better)
– Pull data from Sheets/Airtable into Perplexity API (if possible) where it will perform a prompt.
– Write Perplexity response back to sheet

I am currently working with a .csv with ~2000 comments that I would like to use for this process.

Hourly Range: $33.00-$66.00

Posted On: June 22, 2024 16:16 UTC
Category: Scripting & Automation
Skills:Google Sheets, Data Entry, Automation, Data Scraping, Zapier, Airtable

Country: USA

click to apply