We’re trying to zap Nationbuilder RSVP’s to a Google Sheet using the ‘Person updated’ trigger in NB.
Basically, if a person RSVP’s to an event, they get a certain tag. We use the ‘Person updated’ trigger, then filter to only include people with the specified tag. If they have that tag, we use the ‘Look up in Google Sheet’ action combined with ‘If person doesn’t exist, add new row’.
This goes swimmingly in the beginning, but as more and more people RSVP to an event (sometimes 1000+), more and more people will pass through the filter, too. Which means the ‘Look up in Google Sheet’ will get triggered a lot, even though nothing happens after the look-up.
The result? We reach 5 tot 10k tasks for an event of 1.000 people. This doesn’t seem proportional to us for what seems like a fairly typical use case.
Maybe I’m overlooking something simple?
An alternative I’ve thought of is adding a second task after the Google sheet lookup, which basically adds a second tag to the person in Nationbuilder, which then can be used to filter out the person the next time. Problem with this: it adds a lot of clutter in our NB tags.
Hope all of this makes sense.
Thanks a lot in advance.
Best answer by Troy TessaloneView original