Skip to main content
Best answer

Google sheet update info


Hello,

I successful created zap to update info from trigger Planfiks to google sheets.

When i add/update info in Planfiks zappier add/update this info to sheets, but when i delete info from Planfiks, the info in sheets doesn’t disappear. 

How can i solve this issue?

 

Best answer by ForYourITBest answer by ForYourIT

Hi @Ksistof ,

This completely depends on the app you are trying to integrate. But in most cases an “update” is only a change of data within something that already exists, and keeps existing.

An automation for a delete event would have to be created separately to make actions on that. Otherwise, it would be “weird” to do the same Action on either a change in data & a delete of data. What you are telling the computer (Zapier) is what to do and when  to do it. So you will have to make another Zap workflow that does something in a delete event: 

Hope this helps you! let me know if you have any other questions.

~Bjorn

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

ForYourIT
Forum|alt.badge.img+7
  • Tinkerer
  • 259 replies
  • November 9, 2020

Hi @Ksistof ,

Can you please specify your current Zap workflow a bit more? What do you use as Trigger, Actions etc. ? Screenshots really help a lot!

I expect that you only have a Trigger when something is added/updated in Planfiks and then act on it. However, if you like to remove something as well you need another Zap workflow which acts on a delete event and then delete something in Sheets.

Let me know if this helped you or if you have any more questions

~Bjorn


  • Author
  • Beginner
  • 2 replies
  • November 9, 2020
ForYourIT wrote:

Hi @Ksistof ,

Can you please specify your current Zap workflow a bit more? What do you use as Trigger, Actions etc. ? Screenshots really help a lot!

I expect that you only have a Trigger when something is added/updated in Planfiks and then act on it. However, if you like to remove something as well you need another Zap workflow which acts on a delete event and then delete something in Sheets.

Let me know if this helped you or if you have any more questions

~Bjorn

 

 

i thought, that if i delete smth in Planfiks it means “update”.

Here is trigger shoot:

next step (here works fine)

last step

updating works well, but not i case then i delete smth in planfiks.

In this case,then i delete smth in planfiks,  in sheet remain last putted info.


ForYourIT
Forum|alt.badge.img+7
  • Tinkerer
  • 259 replies
  • Answer
  • November 9, 2020

Hi @Ksistof ,

This completely depends on the app you are trying to integrate. But in most cases an “update” is only a change of data within something that already exists, and keeps existing.

An automation for a delete event would have to be created separately to make actions on that. Otherwise, it would be “weird” to do the same Action on either a change in data & a delete of data. What you are telling the computer (Zapier) is what to do and when  to do it. So you will have to make another Zap workflow that does something in a delete event: 

Hope this helps you! let me know if you have any other questions.

~Bjorn


  • Author
  • Beginner
  • 2 replies
  • November 10, 2020
ForYourIT wrote:

Hi @Ksistof ,

This completely depends on the app you are trying to integrate. But in most cases an “update” is only a change of data within something that already exists, and keeps existing.

An automation for a delete event would have to be created separately to make actions on that. Otherwise, it would be “weird” to do the same Action on either a change in data & a delete of data. What you are telling the computer (Zapier) is what to do and when  to do it. So you will have to make another Zap workflow that does something in a delete event: 

Hope this helps you! let me know if you have any other questions.

~Bjorn

Thank you for answer, it helped :)


ForYourIT
Forum|alt.badge.img+7
  • Tinkerer
  • 259 replies
  • November 10, 2020

Great @Ksistof to hear! Please mark my comment as the answer so it might help others as well!

Have a great day
~Bjorn