Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi there,

 

I’m currently on a company plan but posting from my personal account which also has a similar Zap in place. 

 

The purpose of my zap is to detect when someone replies back to me from LinkedIn and I’d want to see the status in my Google Spreadsheet be switched from FALSE to TRUE. However, I don’t see an option to change it from FALSE to TRUE or does it automatically switch. 

 

In the screenshots below, “choose action event” is set to “lookup spreadsheet row” and shows an option of bottom up value. However, under my company account  the “choose action event” is create spreadsheet row and I no longer see an option to select true or False. 

 

Please help. Happy to do a video on this too

 

I’ve included some screenshots detailing this. 

 

The pictures that you’ve provided don’t show the full zap so if I had to guess what the issue is, it’s that you probably need to add another step.

Step 1 tLinkedIn] (Trigger) - When XYZ happens on LinkedIn…

Step 2 >Google Sheets] - Lookup value in Google Sheets. - Find the row/column that you need to update.

Step 3 pGoogle Sheets] - Update the value from Step 2

---

If you can screenshot your entire zap it would be more helpful. I’m assuming that you’re trying to do step 2 and 3 both inside of step 2?

Thanks for the quick response!!!

 

 

 

Moderator note: images cropped and/or obfuscated to remove personally identifiable information.

 

 

Hi @AlexPeralta2020 ,

Circling back on this as I see you have been working with Patrick in Support! I am posting their response below in an effort to help other users who may encounter a similar issue.

Please let us know if you have any additional questions- happy to help!

The output in the Status column is going to reflect whatever data is caught by the webhook for as long as the Google Sheets action is using the dynamic data from the "Has Reply" field. The data that's received is ultimately determined by whichever app the hook is pulling data from, and any edit to what's received would need to be done through that app.

This said, you are able to make a manual output for the Google Sheet. If the column is always going to read "True", you can change the output by deleting the dynamic value for Status and changing the value to just say "True".

Terms & Conditions