I am trying to send automatic text messages using a spreadsheet and GOTO connect. My idea is that every time a contact is added in the last row a message is sent to the added phone with the added name.
So far I have been successful only once, it seems to have problems choosing the phone number which should be the last one added.
How can I guarantee that Zapier always takes that last added data in the spreadsheet?