Best answer

Trello-GSheets Create a new spreadsheet & populate sheet with card data

  • 22 February 2022
  • 2 replies
  • 20 views

Hello! New to Zapier and trying to achieve the following:

1. Trigger: New card is created in Trello
2. Action: Create a new spreadsheet copied from a template and use the card name as the spreadsheet title
3. Action: Map Trello card field data into newly created spreadsheet cells

I’ve managed to setup the first action, but struggling to populate the spreadsheet with card information.
 


My thinking was to create a secondary action within the same zap to update the newly created spreadsheet. When selecting what spreadsheet to update, I figured I’d be able to reference the spreadsheet from the second step:
 


However, the zap isn’t able to find the spreadsheet based on it’s ID or URL.


It seems like my only option is to pick a set spreadsheet and I’m not able to choose a variable.

How can I go about setting up an action that “links” with another action?

TIA! :)

icon

Best answer by Troy Tessalone 22 February 2022, 03:54

View original

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

Userlevel 7
Badge +14

Hi @h.c.m 

Check out this related topic for help:

 

Hi @h.c.m 

Check out this related topic for help:

 

Thanks @Troy Tessalone ! I actually found that topic before posting and tried it out but failed. I figured it had something to do with the “lookup” step that I didn’t have in my zap, so figured it wouldn’t work for my use-case. Gave it another shot and it works now! 🎉