How to Mark Rows as Processed in Google Sheets After Running a Scenario?

How To
1

Hey everyone!

I’m running into a little snag with an automation I’m working on, and I’m hoping someone here can help.

Basically, I have a scenario that:

  1. Pulls 5 rows from a Google Sheet (Sheet1) based on some criteria.
  2. Sends that data to Anymailfinder via a POST request.
  3. Uses GPT-3 to create personalized icebreaker messages from LinkedIn profiles.
  4. Stores the data for later.

It’s all working fine, but the issue is that I need to mark those 5 rows as “processed” so that the next time I run it, it grabs the next 5 rows instead of repeating the same ones.

I’m thinking something like adding a “Processed” label in a column and filtering that out in the next run, but I’m not sure how to set that up. Anyone have tips on how to do this? Would love any advice or ideas!

Thanks in advance! :raised_hands:

1 Like
2

Hi @Tomer_Weizman

yes you need to add a column in the sheet for label as “processed”. Then after your automation, you can add “update a row” module to update the status as “processed” and can add filter in your google sheet " search rows" module to filter the rows by the status.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation