I have a spreadsheet with hundreds of companies and their URL. I need to scrape the website’s text, look for any reference to Artificial Intelligence and then post a summary of the product and it’s AI use if found back to the spreadsheet. I can start the process with a manual trigger, but then I am having difficulty with iterating back through to the next spreadsheet line item when the process is complete.
Question
How do I automate website text scraping for AI references and update it back to a spreadsheet?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Community Manager
- 9676 replies
Welcome to the Community,
Not sure what apps are you using in the Zap, but presumably it’s using a “New Spreadsheet Row” type of trigger which only runs for new rows that are added to the spreadsheet and doesn’t automatically run for the existing rows in the spreadsheet. Is that the issue here?
If so, to get the Zap to go through the rest of the rows in the spreadsheet you could use a one-time transfer to run the Zap for each of the existing rows. You can learn more about this here: Transfer existing data using a Zap
Hope that helps, but do let me know if I’ve misunderstood or you run into any trouble on that at all. Happy to assist further! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.