I need to be able to capture the text of the updated row and or cell and then have it forwarded using gmail. I have the zap between google spreadsheets and gmail working fine and I receive an email whenever an update is made, however it does not provide me the context of the cell or the cell to reference that has changed. Is this possible for this to be completed?
Best answer by jesse
@cadetcrasher to echo what Andrew said, this isn’t possible with the current Google Sheets integration on Zapier - the cell that gets updated isn’t currently returned in the API call being made. As a workaround, you might try something like Airtable where you can set up filtered views and trigger on new records in that view. You may have to play around with the conditionals a bit but depending on the outcome you’re after, you may be able to get something to work going that route. Hope that helps!