{"Status":true,"Message":"","Response":{"post":{"postuid":"s9wiedkrlb","tenantuid":"d8b744fc-2e70-4089-bb80-dd1d08f6c7b2","projectuid":"239698c5-f7eb-4574-8cc8-c6568f08b3a0","title":"Save SMS Replies to Google Sheets using Zapier","slug":"article/s9wiedkrlb-integrations-zapier-google-sheet-sms-reply","html":"\u003Cp\u003EThis article details how to use \u003Ca href=\u0022/article/3hx4lytkex-integrations-zapier\u0022\u003EZapier integration\u003C/a\u003E with DailyStory to write text message replies to a Google Sheet. Specifically, when a customer texts your SMS number a row is written to a specific Google Sheet.\u003C/p\u003E\u003Ccite class=\u0022recommended\u0022\u003E\u003Cspan class=\u0022title\u0022\u003E\u003Ci class=\u0022fa-duotone fa-circle-exclamation\u0022 aria-hidden=\u0022true\u0022\u003E\u003C/i\u003ERecommended\u003C/span\u003E\u003Cp\u003E\u003Cstrong\u003ENote\u003C/strong\u003E: this requires DailyStory Zapier app version 1.10.0 or later.\u003C/p\u003E\u003C/cite\u003E\u003Cp\u003EBelow are the steps:\u003C/p\u003E\u003Col\u003E\u003Cli\u003ECreate a new sheet in Google sheets that has at least the following columns:\u003C/li\u003E\u003C/ol\u003E\u003Cp\u003EIn this example a Sheet called Zapier SMS Replies was created with the columns: Name, Mobile Phone, and Message.\u003C/p\u003E\u003Cimg class=\u0022lazy-load\u0022 data-src=\u0022https://graffiti-auf7e6dwhxhcbwek.z03.azurefd.net/d8b744fc-2e70-4089-bb80-dd1d08f6c7b2/239698c5-f7eb-4574-8cc8-c6568f08b3a0/be3d05509c569fbec65ac9b1490f80a0.png\u0022 style=\u0022\u0022 alt=\u0022\u0022/\u003E\u003Col start=\u00222\u0022\u003E\u003Cli\u003ECreate a new Zap with the DailyStory \u0026#34;SMS Reply Received\u0026#34; trigger.\u003C/li\u003E\u003C/ol\u003E\u003Cp\u003EAdd the DailyStory Trigger: SMS Reply Received:\u003C/p\u003E\u003Cimg class=\u0022lazy-load\u0022 data-src=\u0022https://graffiti-auf7e6dwhxhcbwek.z03.azurefd.net/d8b744fc-2e70-4089-bb80-dd1d08f6c7b2/239698c5-f7eb-4574-8cc8-c6568f08b3a0/eecfa6c1ddb998ae30601197fe8c9d40.png\u0022 style=\u0022\u0022 alt=\u0022\u0022/\u003E\u003Col start=\u00223\u0022\u003E\u003Cli\u003EAdd the \u0026#34;Google Sheet\u0026#34; action to the Zap:\u003C/li\u003E\u003C/ol\u003E\u003Cimg class=\u0022lazy-load\u0022 data-src=\u0022https://graffiti-auf7e6dwhxhcbwek.z03.azurefd.net/d8b744fc-2e70-4089-bb80-dd1d08f6c7b2/239698c5-f7eb-4574-8cc8-c6568f08b3a0/aab475d0b2e2d94c524c4197a981069a.png\u0022 style=\u0022\u0022 alt=\u0022\u0022/\u003E\u003Col start=\u00224\u0022\u003E\u003Cli\u003ESelect the \u0026#34;Create Spreadsheet Row\u0026#34; event:\u003C/li\u003E\u003C/ol\u003E\u003Cimg class=\u0022lazy-load\u0022 data-src=\u0022https://graffiti-auf7e6dwhxhcbwek.z03.azurefd.net/d8b744fc-2e70-4089-bb80-dd1d08f6c7b2/239698c5-f7eb-4574-8cc8-c6568f08b3a0/0fd9c4ee50347369ddd222e4de0cd359.png\u0022 style=\u0022\u0022 alt=\u0022\u0022/\u003E\u003Col start=\u00225\u0022\u003E\u003Cli\u003EConnect your Google account to the Zap:\u003C/li\u003E\u003C/ol\u003E\u003Cimg class=\u0022lazy-load\u0022 data-src=\u0022https://graffiti-auf7e6dwhxhcbwek.z03.azurefd.net/d8b744fc-2e70-4089-bb80-dd1d08f6c7b2/239698c5-f7eb-4574-8cc8-c6568f08b3a0/ad051d3976b7e0fca507b6e8faa15f2f.png\u0022 style=\u0022\u0022 alt=\u0022\u0022/\u003E\u003Col start=\u00226\u0022\u003E\u003Cli\u003EConfigure the Action\u003C/li\u003E\u003C/ol\u003E\u003Cp\u003ESelect the Google Drive, Spreadsheet and Worksheet. For example, the Spreadsheet created above is \u0026#34;Zapier SMS Replies\u0026#34;.\u003C/p\u003E\u003Cp\u003ENext, use the values from the DailyStory App Trigger to populate the row columns of Name, Mobile Phone, and Message.\u003C/p\u003E\u003Cimg class=\u0022lazy-load\u0022 data-src=\u0022https://graffiti-auf7e6dwhxhcbwek.z03.azurefd.net/d8b744fc-2e70-4089-bb80-dd1d08f6c7b2/239698c5-f7eb-4574-8cc8-c6568f08b3a0/c142c8fbea7d8e165c990111d4794608.png\u0022 style=\u0022\u0022 alt=\u0022\u0022/\u003E\u003Col start=\u00227\u0022\u003E\u003Cli\u003ESave and publish your Zap\u003C/li\u003E\u003C/ol\u003E\u003Cp\u003EThat\u0026#39;s it. When an incoming SMS reply or message is sent to your DailyStory mobile number, that message will be written to the spreadsheet.\u003C/p\u003E","publish_status":0,"post_type":"Article","author":{},"featured_image_updating":false,"meta_description":"This article details how to use Zapier integration with DailyStory to write text message replies to a Google Sheet. Specifically, when a customer texts your SMS number a row is written to a specific Google Sheet. Note : this requires DailyStory Zapier app version 1.10.0 or later. Below are the steps: Create a new sheet in Google sheets that has at least the following columns: In this example a Sheet called Zapier SMS Replies was created with the columns: Name, Mobile Phone, and Message. Crea ...","display_toc":true,"has_workingcopy":false,"allow_indexing":true,"sort_order":2,"total_views":877,"date_published":"2023-08-14T20:30:16","date_updated":"2025-05-16T19:21:28.597","date_created":"2025-04-24T15:03:16.29"}}}