Hello,
Perhaps a noob question, but I’m mapping a status schedule from Google Sheets that looks like this:
I keep getting a "[400] (#100) This field must be a non-empty string." Error from Facebook Ads Campaign Management when mapping the column. According to the docs, the status needs to be set to one of the following: ACTIVE, PAUSED, ARCHIVED, or DELETED.
What am I doing wrong here?
Before the facebook ad campaign add in filter that filters where (F) exists.
Hello,
Thanks for the super quick response. I’m new to Make and automation in general. Is this correct? I still get the same error after adding this filter.
Yes try it. Lets see how it goes. 
Thank you for your message!
To effectively search in MAKE in google sheet search module, you need to specify search criteria. For example, if every row in your Google Sheet has a value in column A, you can set the criteria to search for rows where column A is not empty. Additionally, you can specify that a search should exclude rows where column C is empty.
It’s also crucial to update the Google Sheet with feedback after processing each row. Adding a status or a binary value indicating that the necessary action has been completed for that row helps prevent duplicating entries, such as posting the same information on Facebook multiple times.
But once you use a search criteria you will get data
