How to loop over multiple rows in google Sheets

1

Hi there,

I want to gather updates from an RSS feed over time, store them in a Google Sheets, and then eventually loop over the collated updates over a period of time (e.g. a day) and send them as an email. How would I do this in Pipedream, and is there any way to loop a logic across multiple rows a Google Sheets?

2

Hi @dominic.soon,

First off, welcome to Pipedream! Happy to have you!

For your usecase, I would suggest the flow as follow:

  • Create a workflow with RSS New Item in Feed trigger, then add the action to write the result into the Google Sheet in a way that all item in a day go into a sheet. So everyday you should create a new sheet
  • Then you can create another workflow having scheduler trigger that trigger once everyday. Add the Google Sheet action to get all rows into Google Sheet of the day; then add a Node.js action to combine all the rows data into email content; finally add the send email action (using Send Grid for example), with the email content

This way, you dont need to loop anything. Just get all data for the day and combine them

3

Thanks! This is a great idea. Appreciate you thinking through this.

4

Actually, I also want to download attachments associated with each items which I am currently storing separately in a Google Drive. Is it possible to do this? Playing around with the Google Drive integration, it doesn’t seem like I can download a file based on a path e.g. /Storage/.pdf but I need to link to a specific file.