In Hubspot we have a numerical property which is required when a deal is marked Won. Therefore, all Won deals will have a non-zero value in this property (it’s typically in the single digits but could range up to 100+). Let’s call it “number of bananas”
Here’s what I’m trying to do:
When a deal is Won → Create a Google Sheet WHERE THE NUMBER OF ROWS MATCHES THE INPUT FROM HUBSPOT. In other words, if Hubspot has “number of bananas” set to 3, then the sheet created has 3 rows.
I’m able to create the sheet using event=Create Spreadsheet in Google Sheets (technically I’m duplicating from from an existing template, since I have row 1 formatted with headers). But I can’t figure a way to dictate how many rows should be created.
Is this possible? and if yes please tell me howwwwwww <3
