Marking a row after a search has taken place

Questions
1

:bullseye: What is your goal?

To mark the row in google sheets after it has been searched for data, avoiding it being searched if run again.

:thinking: What is the problem & what have you tried?

If putting the Google Sheets update a row module after the search row (8th module from start) it only populates the rows that have been as in attachment/image “update a row” it only updates the rows that have had the error found or none at all because it doesn’t know what row to mark -not all rows with the month filtered.

e.g. Automa

update row
update row615Ă—194 17.5 KB

Look for incorrect entries (copy) Working copy.blueprint.json (159.4 KB)

overview
overview1240Ă—404 62.3 KB

tion looks through all entries with month December and disregards any that have dates as expected and keeps a note of those rows with errors. It then adds YES to that row, not to all rows with Month of December.

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

update row.png
update row.png615Ă—194 17.5 KB

3

Hey there,

can you show a screenshot of the search module configuration? Is it searching for and returning all entries where the month is December?

Also you can use this button at the bottom of the screen to automatically align your modules:

image
image867Ă—122 9.15 KB

4

image
image916Ă—816 64.7 KB

and

image
image663Ă—813 37.1 KB

image
image809Ă—825 46.2 KB

@Stoyan_Vatov Not sure what “search module” you mean.

5

Yeah that one, the Google Sheets Search Rows module - from what I can tell, its already searching for specific entries, so its returning only those specific entries so only these rows are getting tagged.

6

Yes so a few questions:

is this the best way to look for current month and month plus one and how can I add an update row system in?

7

If you want to tag all of the rows, then no. You need to pull all of the rows from the sheet. Then do the filtering afterwards to get only the rows you are interested in.

1 Like
8

So if at the end after the email is sent I could do a Google Sheets Range (move the second one in the automation to the end) and then do an update row?

This I assume would mean that I knew the automation had completed?

EDIT- just realised it may not work if the filters earlier on deemed new rows as being okay and then not carrying forward- should I put an additional route in that only deals with marking the rows?