Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. After setting up the trigger, you should be prompted to add an Action. Select to add one.

  2. Choose Google Sheets.

  3. For an action, select Create Spreadsheet Row. Select ‘Save + Continue.

  4. You should now be on Select Google Sheets Account. Click Connect a New Account and allow Zapier access. When you click continue, you will be prompted to link the Spreadsheet and Worksheet you've created.

  5. On the Set Up Template page, select the Spreadsheet dropdown. Select the spreadsheet you just set up.

  6. Select the worksheet that you added the headers to. The headers should now appear as drop down fields beneath the worksheet field.

  7. Image Removedimage-20240702-185602.pngImage Added

  8. Proceed to match up the column headers as follows: 

    1. username = Form Meta Username

    2. timestart = Form Time Start

    3. timeend = Form Time End

    4. caseid = Form Case @case ID

    5. case_name = Form Case Create Case Name

  9. After matching up the fields, select continue.

  10. You should be brought to a page where you can test the integration. Select Create and Continue.

  11. You should receive a notification that the action was successful or not.

    1. If successful, proceed to the spreadsheet and confirm it now has some data in it!

    2. If unsuccessful, please review the steps to ensure everything is setup correctly.

  12. After receiving the notification that the action was successful, select Finish.

  13. Turn on your zap!

...