--- title: "Zapier – Trigger – User Access Info" slug: "zapier-user-access-info" updated: 2022-07-08T00:17:23Z published: 2022-07-08T00:17:23Z --- > ## Documentation Index > Fetch the complete documentation index at: https://support.lightspeedvt.com/llms.txt > Use this file to discover all available pages before exploring further. # Zapier – Trigger – User Access Info We offer a Zapier trigger that will poll our database in order to return a list of active users and their sign in activity. This trigger is useful to take actions based on last access date/time. An example of use, would be to tag in your CRM of choice, all users that have not signed in to LSVT in the past 7 days. ## Get Started ### Trigger Setup [Click here](https://zapier.com/app/zaps) to access your Zapier Zaps. Create a Zap ![2021-07-19_11-36-43](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_11-36-43.jpg){height="" width=""} On the resulting screen, choose to create a trigger and search for LightSpeed VT app. Then select the app. ![2021-07-19_11-40-52](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_11-40-52.jpg){height="" width=""} After choosing LightSpeed VT app, select Access Info as the trigger event and click continue. ![2021-07-19_11-43-24](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_11-43-24.jpg){height="" width=""} Choose your LightSpeed VT Zapier account from your list of connected account. ![2021-07-19_11-49-19](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_11-49-19.jpg){height="" width=""} :::(Warning) If you never connected your account previously, please refer to this article. ::: Next, you will be presented with query parameters that will allow you to filter out data. All are optional. * **System Id**: If your API account gives you access to multiple systems, you should narrow down your search by specifying a system id * **Location Id**: Results would be for the specified location id * **User Id**: Would return only 1 record for the specified user * **Starting Access Date**: Returns records for users that accessed LSVT after specified date * **Ending Access Date**: Returns records for users that accessed LSVT before specified date ![2021-07-19_13-06-25](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_13-06-25.jpg){height="" width=""} The final trigger step is to test the trigger. ![2021-07-19_13-38-41](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_13-38-41.jpg){height="" width=""} The test will retrieve sample data that will provide several fields and their corresponding values: id, userid, firstName, lastName, jobPosition, team, accessDate, accessIP, locationId and email. ![2021-07-19_13-39-46](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_13-39-46.jpg){height="" width=""} ### Date Formatting Part 1 Before you set up an Action, you will need to format the date/time sent in the response from the trigger you just created, to match Zapier format and timezone. Click on **Format** to add a formatting step. ![2021-07-19_14-12-25-1](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_14-12-25-1.jpg){height="" width=""} Then choose **Date / Time** from the **Action Event** menu choices and continue. ![2021-07-19_14-53-17 \(1\)](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_14-53-17%20%281%29.jpg){height="" width=""} On the next step, choose to transform using **Format**. ![2021-07-19_14-55-47 \(1\)](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_14-55-47%20%281%29.jpg){height="" width=""} For **Input** value, look for the **Last Access Date/Time** in the list of sample data. ![2021-07-19_14-58-14](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_14-58-14.jpg){height="" width=""} The next options are: * **To Format**, choose **MM/DD/YY (01/22/06)** * **To Timezone**, choose **UTC** * **From Format**, do not specify anything * **From Timezone**, choose **US/Pacific** ![2021-07-19_15-14-21](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-14-21.jpg){height="" width=""} You can then test the action. ![2021-07-19_15-15-15](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-15-15.jpg){height="" width=""} :::(Info) You should rename this step to avoid confusion and allow you to distinguish the various steps later on. ::: ### Date Formatting Part 2 You will need to add another formatter action before finalizing your zap. Click the + icon below the formatting step you just created to add a new step. ![2021-07-19_15-18-03](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-18-03.jpg){height="" width=""} You will follow almost the same instructions as before, by choosing “Format” for action again. ![2021-07-19_15-19-53](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-19-53.jpg){height="" width=""} Then choose **Date / Time** from the **Action Event** menu choices and continue. ![2021-07-19_14-53-17](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_14-53-17.jpg){height="" width=""} On the next step, choose to transform using **Format**. ![2021-07-19_14-55-47](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_14-55-47.jpg){height="" width=""} This time, for **Input** value, you will need to type in: `{{zap_meta_human_now}}`. This code will retrieve the date/time when the Zap runs, which will be used later on to compare the time difference between the last access and the Zap. :::(Warning) As soon as you enter `{{zap_meta_human_now}}` into the field, it will transform to show as in screenshot below (**Zap Meta Human Now**: No data) ![2021-07-19_15-27-26](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-27-26.jpg){height="" width=""} ::: The next options are: * **To Format**, choose **MM/DD/YY (01/22/06)** * **To Timezone**, choose **UTC** * **From Format**, do not specify anything * **From Timezone**, set to the timezone configured for your Zapier account ![2021-07-19_15-35-43-1](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-35-43-1.jpg){height="" width=""} Test the action and continue. ![2021-07-19_15-37-34](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-37-34.jpg){height="" width=""} :::(Info) You should rename this step to avoid confusion and allow you to distinguish the various steps later on. ::: ### Optional Filter Depending on your needs, you may want to add a filter to your Zap to only process Zaps that are matching your criteria. For example, only send Zaps with users that did not sign in the past 7 days and send them an email or add a tag to their customer record in your CRM. To create a filter, click the + icon below your last step action and choose **Filter**. ![2021-07-19_15-42-08](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-42-08.jpg){height="" width=""} Configure your desired settings by first choosing the data that will be used for comparison. For this article, we will first select the formatted date we created in step 1. ![2021-07-19_15-50-30](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-50-30.jpg){height="" width=""} Then (Date/time) Before for condition ![2021-07-19_15-52-05](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-52-05.jpg){height="" width=""} and finally choose the Zapier formatted date you created in the second formatting step. ![2021-07-19_15-54-08](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-54-08.jpg){height="" width=""} Then type a space and add -7d and click continue. ![2021-07-19_15-58-27](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_15-58-27.jpg){height="" width=""} This filter would only send a Zap for any users with a last LSVT access that is 7 days before time of polling from Zapier. ### Final Action Click on the + icon at bottom to create the final action to be taken. You can choose any Apps and follow the same principles from any other Zaps to send data to your app. Example below is for sending data to a Google Sheet ![2021-07-19_16-08-14](https://cdn.document360.io/4b9cf9ed-c1b6-4848-a21b-3a266775c016/Images/Documentation/2021-07-19_16-08-14.jpg){height="" width=""} Turn on your Zap. Data will be retrieved everyday shortly after midnight in your timezone.