What are you trying to achieve?
First-time Make user trying to achieve the following using a scenario between Google Sheets and Kit (formerly ConvertKit):
- Watch a Google Sheet for new rows
- Check the GDPR status column for a ‘0’ or ‘1’
- If GDPR status = 0, look for the corresponding email address (from the same row) in Kit and delete it from Kit (I now realise that option is not available, so it will be apply tag A)
- If GDPR status = 1, look for the corresponding email address (from the same row) in Kit and add a specific tag (e.g. tag B)
Steps taken so far
I started a new Make scenario by successfully adding a Google Sheet ‘Search Rows’ module using the Sheet that contains the existing records.
I then added a filter (inside the module) to find all the records where the GDPR status equals ‘1’. This worked (as I could see, the resulting bundles matched the same number of rows Sheets displays if the filter is manually added).
But I know this scenario only checks the existing database for an existing filter.
What I don’t know is whether I should edit this scenario to add the new steps to achieve my goal of watching for new rows.
Or do I need to start again as we want the scenario to apply to NEW rows being added (and not worry about the existing database).
At the same time, I now see how this existing scenario could potentially be used to delete the existing subscribers with a GDPR status of ‘0’. (That would be better than manually finding the 40 or so we know to be in ConvertKit!)
Subsequently, I added an ‘If’ filter between Sheets and ConvertKit (with the view that I’ll remove the GDPR status filter from the ‘Search Rows’ module. But no idea what to do next!)
