Am I correct in assuming that Zapier can not put in data from a google sheet into a referenced Webflow CMS field? Not even if the data from the sheet match exactly the possible references? I have tried several times and different ways, but keep getting errors.
Thinking now to put the data from google sheets into plain text fields, and keeping the referenced fields. I guess I would have to set the referenced field manually in Webflow in order to have the record show up in the collection pages of the referenced fields. Is that correct? It would destroy the idea of automating workflow, but still better than putting in manually hundreds of records, thousands of fields.