Skip to main content
Question

Rows aren't updating in Google Sheets from Slack, and incomplete cards are created in Trello despite successful Zap execution.

  • February 19, 2024
  • 2 replies
  • 114 views

Context: I’ve 2 Zaps running Live to automate my Workflow. 

Zap 1: Whenever I save a slack msg, this Zap sends it to my Google Sheet as a new row

  • Input from Slack to GS:  Task| Slack Link| Tagged by| Date 

 

  • (Slack sends Date in this format: 2023 06 08 1:29:30) 
  • (In Google Sheet I’ve formated a Month-Day column that turns the above date to : Jun-8) 
     

Zap 2: Whenever a new row is created this Zap creates a task in trello 

  • Input from Google Sheet to Trello 
    Event in trello: Create card 
    Card title: Month-Day Column| Tagged by  
    e.g (Jun 8| Pallav) 
    Card desc:
    Check out this task: [Slack URL] 

Video Link: Loom (please check this)
Observation: 

Zap 1: 
Initially worked, after that the rows. in Google Sheet stopped updating. 
The rows are getting pushed but it doesn’t appear here. 

Zap 2: 
This works. New cards are created but incomplete.  
meaning in Google sheet, you won’t find this row, but it appears in the Trello card. 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 19, 2024

Hi @Vaishak 

Zaps add new rows in the first blank row.

Formulas in fields make a row not empty.

You can add the formula in the field within the Zap step configuration.

 

 

Otherwise, consider using an app like Airtable instead of GSheets.

Airtable has a Date field type: https://support.airtable.com/docs/date-and-time-field


  • Author
  • Beginner
  • February 20, 2024

Oh. thanks. That makes sense now. 
Thanks a lot