WEBVTT

00:02.000 --> 00:05.000
We'll start with a sample app.

00:17.000 --> 00:20.000
Let's add a hidden field containing today's date.

00:31.000 --> 00:34.000
Let's add the button adding a row to our spreadsheet.

00:43.000 --> 00:46.000
We need to get the server address from Zapier.

00:46.000 --> 00:49.000
Let's create a new Zap.

00:52.000 --> 00:56.000
To enable Zapier to read Calcapp data, we need a Webhooks trigger.

00:58.000 --> 01:01.000
A "Catch Hook" is perfect for capturing Calcapp data.

01:06.000 --> 01:10.000
We can skip this step if Zapier should react to all data.

01:12.000 --> 01:15.000
It's time to copy the server address to the clipboard.

01:19.000 --> 01:21.000
Paste the address into Calcapp Creator.

01:23.000 --> 01:30.000
Preview the app and send data to Zapier to continue.

01:52.000 --> 01:55.000
Now, let's connect Google Sheets to your app.

01:57.000 --> 02:02.000
We'll create a new spreadsheet row, but you can also update an existing row.

02:07.000 --> 02:11.000
You'll need to connect your Google account if you haven't already.

02:14.000 --> 02:17.000
Let's create a Google Sheets spreadsheet to hold the data.

02:17.000 --> 02:21.000
Create one column for every app field you want to capture.

02:35.000 --> 02:38.000
Select the target spreadsheet you just created.

02:43.000 --> 02:46.000
Select the worksheet.

02:50.000 --> 02:54.000
Associate the Calcapp fields with the columns you created.

03:25.000 --> 03:28.000
Test the connection if you like or skip it.

03:35.000 --> 03:38.000
Name your Zap and enable it.

03:48.000 --> 03:51.000
It's time to test the app!

03:55.000 --> 03:58.000
...and the data appears as a new row.

03:58.000 --> 04:03.000
Format the date column values as dates.

04:04.000 --> 04:06.000
Thanks for watching!