# 5	how to use zapier with google sheets

Viewport: 3376x1896 @2x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to use Zapier with Google Sheets
   - body: In this interactive tutorial we will be look at how you can create a Zapier integration making use of Google sheets as one of its trigger app. 
   - voiceover: This tutorial provides a step-by-step guide on how to set up and use Zapier with Google Sheets for automated workflows. Follow these instructions to integrate Google Sheets as a trigger action and chain multiple actions together.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyjhoa000a0cky37axcp6a.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Click Create button
   - source type: IMAGE
   - target: (174.5290351255352, 85.02580566058654), rect: top=78 left=74.4453125 width=91.109375 height=24
   - hotspots: 1
     - hotspot_01 (174.5290351255352, 85.02580566058654), rect: top=78 left=74.4453125 width=91.109375 height=24
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Click on the 'Create' button in Zapier to start creating a new Zap.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyjqv0000c0cky283f3kt8.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xxz9q40000039pc4yf1avd.png
2. step_02 [image] - Navigate to Zaps - Automated workflows
   - source type: IMAGE
   - target: (166.7225795288831, 141.66451858651766), rect: top=154 left=73 width=123.7265625 height=20
   - hotspots: 1
     - hotspot_01 (166.7225795288831, 141.66451858651766), rect: top=154 left=73 width=123.7265625 height=20
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Go to 'Zaps' - Automated workflows section in the dashboard to begin setting up your Zap.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyjs3d000d0cky2xwd1xkk.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xxzap80001039pj6l7lbru.png
3. step_03 [image] - Click on Trigger for the first trigger action.
   - source type: IMAGE
   - target: (788.8645210704487, 484.19355377335285), rect: top=486.6499938964844 left=732.9000244140625 width=46.31170654296875 height=16.5
   - hotspots: 1
     - hotspot_01 (788.8645210704487, 484.19355377335285), rect: top=486.6499938964844 left=732.9000244140625 width=46.31170654296875 height=16.5
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Click on 'Trigger' to define the first action that will kickstart the automated workflow.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyjudm000e0cky2qxp4262.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xxzfvz0002039plm06jt8i.png
4. step_04 [image] - Select Google sheets as the desired trigger action.
   - source type: IMAGE
   - target: (686, 465), rect: top=458.5 left=612 width=98.515625 height=17
   - hotspots: 1
     - hotspot_01 (686, 465), rect: top=458.5 left=612 width=98.515625 height=17
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Choose 'Google Sheets' as the desired trigger action from the list of available apps.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyjwc3000f0ckyhkbl0009.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xxzlmm0003039pmjk3u7d2.png
5. step_05 [image] - Select the trigger event for the Google sheets trigger.
   - source type: IMAGE
   - target: (1288.8767895249928, 332.492176610608), rect: top=334 left=1309 width=300 height=15
   - hotspots: 1
     - hotspot_01 (1288.8767895249928, 332.492176610608), rect: top=334 left=1309 width=300 height=15
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Pick the trigger event for Google Sheets, such as 'New Spreadsheet Row' or 'New or Updated Spreadsheet Row'.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyjxsl000g0ckybozy9bm0.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xxzoes0004039pne3p9na1.png
6. step_06 [image] - Now integrate your Gmail account in which you have the spreadsheet which needs to be automated.
   - source type: IMAGE
   - target: (1283.1203068242228, 419.4742483071879), rect: top=427.5 left=931 width=334 height=39
   - hotspots: 1
     - hotspot_01 (1283.1203068242228, 419.4742483071879), rect: top=427.5 left=931 width=334 height=39
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Integrate your Gmail account that contains the spreadsheet by clicking 'Sign in to Google' and providing your credentials.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyjyyk000h0cky4s3lgetg.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xxzt9w0006039pszq49ewa.png
7. step_07 [image] - Select your Gmail account which has hte google sheet.
   - source type: IMAGE
   - target: (839.9002564983116, 337.5011532695809), rect: top=269.5 left=554 width=320 height=20
   - hotspots: 1
     - hotspot_01 (839.9002564983116, 337.5011532695809), rect: top=269.5 left=554 width=320 height=20
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Choose the Gmail account you just integrated, which has your Google Sheet available.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyk0in000i0ckyb2xt1lec.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xy031d0007039ppl1dn14v.png
8. step_08 [image] - Allow Zapier to access your Google Account.
   - source type: IMAGE
   - target: (1333.0098407712474, 901.2272907665633), rect: top=592.40625 left=700 width=174 height=48
   - hotspots: 1
     - hotspot_01 (1333.0098407712474, 901.2272907665633), rect: top=592.40625 left=700 width=174 height=48
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Grant permission for Zapier to access your Google Account by clicking 'Allow'.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyk1mt000j0ckydw1ubw14.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xy090k0008039pifvk6rxr.png
9. step_09 [image] - Once your Google account is integrated you will be able to select the spreadsheet that is a part of your Google account.
   - source type: IMAGE
   - target: (1282.8668735954204, 340.3658882908442), rect: top=338.109375 left=1309 width=278 height=15
   - hotspots: 1
     - hotspot_01 (1282.8668735954204, 340.3658882908442), rect: top=338.109375 left=1309 width=278 height=15
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Once your Google account is integrated, select the spreadsheet you wish to automate from the dropdown list.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyk2wk000k0cky2k7b73g6.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xy0hcb0009039pz11azz95.png
10. step_10 [image] - Now select the specific worksheet inside the selected spreadsheet.
   - source type: IMAGE
   - target: (1279.8903661515299, 413.2193666540661), rect: top=402.609375 left=1298 width=300 height=36
   - hotspots: 1
     - hotspot_01 (1279.8903661515299, 413.2193666540661), rect: top=402.609375 left=1298 width=300 height=36
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Choose the specific worksheet within the selected spreadsheet to narrow down the trigger event scope.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyk4cl000l0cky16su01no.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xy0lr1000c039pstwo5vpk.png
11. step_11 [image] - Once all the configurations are made successfully for Google sheets trigger event. Now Click on Continue to select the next trigger event.
   - source type: IMAGE
   - target: (1309.6780133805505, 846.4535164194348), rect: top=571.609375 left=924 width=343 height=47
   - hotspots: 1
     - hotspot_01 (1309.6780133805505, 846.4535164194348), rect: top=571.609375 left=924 width=343 height=47
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: After configuring the Google Sheets trigger event, click 'Continue' to proceed to the next trigger event setup.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyk5cc000m0ckyelt48wmc.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xy0qoc000f039pp3a0kj8v.png
12. step_12 [image] - Go ahead to select the second trigger event that you wish to trigger after the Google sheets trigger. You can further keep chaining triggers one after other and keep configure those. 
   - source type: IMAGE
   - target: (682.8276779080566, 428.4308509540866), rect: top=413 left=574 width=270 height=36
   - hotspots: 1
     - hotspot_01 (682.8276779080566, 428.4308509540866), rect: top=413 left=574 width=270 height=36
   - dimensions: 3376x1896 @2x
   - layout: 1 (full)
   - voiceover: Select and configure the second trigger event that will follow the Google Sheets trigger. You can continue chaining more triggers as needed.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyk79n000n0ckydior44lz.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xy130x000g039p4gqoxugw.png
14. [Outro] You have successfully created a Google Sheets automation on Zapier. 
   - body: Now once the selected trigger even happens in the Google sheet the control will flow to the next automation trigger block. 
   - voiceover: You have successfully set up the initial trigger action with Google Sheets. You can now proceed to add more trigger events or finalize your Zap to complete the automated workflow.
   - audio: https://cdn.layerpath.com/cm550eine001mjp0caotxos93/cm5xxyy1s001yjy0c1zhjgq1q/cm5xyjkcn000b0ckycht77qda.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm5xxyy1s001yjy0c1zhjgq1q/tour