How to Automatically Press a Button on New Rows in a Table Connected to an API?

Hi Coda community! :raised_hands:

I’m working on a project where I have a table called Registro_Mensajes. This table is connected to Meta’s API (WhatsApp) via a webhook built in Glitch. Its purpose is to receive incoming WhatsApp messages, and each time a new message is received, a new row is automatically created in the table with the data sent by the API.

In this table, I have a column with a button. What I want to achieve is that when a new message is received (and a new row is created in the table), the button in that new row is automatically pressed.

I’ve tried solving this by creating an automation, but it didn’t work. The issue is that Coda automations don’t recognize the creation of a new row as a modification of any column values, so the automation never triggers.

Has anyone faced a similar issue or knows of a solution to automatically press a button for new rows in this case? I would greatly appreciate any insights, ideas, or workarounds.

Thanks in advance for your help! :blush:

2 Likes

Hey Jose!
I’m not sure how Glitch works but if you’re hitting the insert row endpoint then you can store the addedRowIds and requestId response

You then hit the mutation status endpoint until it’s completed

Then finally you can hit the push button endpoint for the new row

Hope that helps :pray:

1 Like