Hi all,
My two Sales people use a Gsheet to track leads, which I want to Zap directly into Hubspot.
The problem is, I get stuck on the Contact Owner, which is just refusing to play nice.
Here is the sheet, for your reference:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4c11183f-1884-4ab9-aa26-10a6508c8395.png)
sales man 1 is in red, sales man 2 is in yellow.
Here’s the Zap I’ve designed:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/97d70f9b-cb3a-46cf-987b-aaf78671d47c.png)
Here’s the formatter:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/6421628c-e77f-4773-b250-e5333374ca9a.png)
Here’s the ‘Get Owner by email’:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/142058aa-365c-412f-9636-b477dbeb2b6d.png)
Here is the troubleshotting issue I keep encounting:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2c52471c-e08e-416c-9481-c7af564a63cd.png)
How on earth do I fix this?? I’ve read all the posts I thought could help but none of them seem to, and I’m sure this is a very simple fix. What am I missing here?
Thanks!!