Export To Google Sheet

Description:

Export To Google Sheet

Use this action to export data to google sheets.

Steps to configure

  1. You need to create a Google service account.

    Referenece: https://console.developers.google.com

  2. After creating the account you need to generate a JSON credentials file.

  3. Go to Connection Details tab in setup page to add a new additional connection.

  4. Select GOOGLE as connection type and add a unique connection code and upload the generated JSON file.

  5. Create a folder in Google Drive where you wish to place the exported google sheet and and share the folder to created service account user.

  6. Create a folder in Google Drive and and share the folder to the created service account user.

  7. In the properties of this action add the provided connection code in the setup page and the google folder ID.

Allowed Parent Components:

  1. Trigger After Device Drag

  2. Trigger After Device Move

  3. Trigger Before Device Drag

  4. Trigger Before Device Move

  5. Action Group

  6. Action Search

  7. Add Connection

  8. Case

  9. Change Language

  10. Clear All Filters

  11. Clear DataSource

  12. Clear Grid Sort

  13. Confirm Message

  14. Copy StoreRecord

  15. Drag Drop Operation

  16. Duplicate Item

  17. Duplicate StoreRecord

  18. Eval And Execute Expression

  19. Export To Google Sheet

  20. Geo Location

  21. Go Back

  22. Go To First Record

  23. Go To Last Record

  24. Go To Next Record

  25. Go To Page

  26. Go To Previous Record

  27. Import Data

  28. Insert Record

  29. Invoke DataSource

  30. Loop

  31. Loop Records

  32. Multi Sheet Export

  33. Query DataSource

  34. Query DataSource From Aggregate

  35. Reduce

  36. Refresh DataSource

  37. Refresh Navigation Menu

  38. Register State

  39. Remove Connection

  40. Save DataSource

  41. Save Transaction

  42. Save Video Recording

  43. Server Validate

  44. Set As Current StoreRecord

  45. Start Video Recording

  46. Stop Video Recording

  47. Trigger After Delete Record

  48. Trigger After Drop

  49. Trigger After Insert StoreRecord

  50. Trigger After Popup Close

  51. Trigger After Popup Open

  52. Trigger After Query

  53. Trigger After Save

  54. Trigger After Save

  55. Trigger After Select Query

  56. Trigger After Update StoreRecord

  57. Trigger After Upload Attachment

  58. Trigger Before Create

  59. Trigger Before Delete StoreRecord

  60. Trigger Before Drop

  61. Trigger Before Edit Cell

  62. Trigger Before Insert StoreRecord

  63. Trigger Before Popup Close

  64. Trigger Before Popup Open

  65. Trigger Before Query

  66. Trigger Before Query

  67. Trigger Before Record Change

  68. Trigger Before Render

  69. Trigger Before Save

  70. Trigger Before Save

  71. Trigger Before Select Query

  72. Trigger Before Update StoreRecord

  73. Trigger Before Upload Attachment

  74. Trigger On Aggregate Click

  75. Trigger On Any Attribute Change

  76. Trigger On Attribute Change

  77. Trigger On Cell Click

  78. Trigger On Change

  79. Trigger On Click

  80. Trigger On DataStore State Change

  81. Trigger On Day Click

  82. Trigger On Device Click

  83. Trigger On Device Hover

  84. Trigger On Dismiss

  85. Trigger On Drag

  86. Trigger On Drag End

  87. Trigger On Drag Start

  88. Trigger On Drop

  89. Trigger On Enter Key Press

  90. Trigger On Event Click

  91. Trigger On Event Drop

  92. Trigger On Event Resize

  93. Trigger On First Visit

  94. Trigger On Key Press

  95. Trigger On Mouse Over

  96. Trigger On No Data Action Button Click

  97. Trigger On Page Active

  98. Trigger On Page Exit

  99. Trigger On Page Init

  100. Trigger On Page Switch

  101. Trigger On Record Active

  102. Trigger On Row Click

  103. Trigger On Row Selection Change

  104. Trigger On Scan

  105. Trigger On Tab Active

  106. TriggerOnCellDoubleClick

  107. TriggerOnRowDoubleClick

  108. Wait

  109. Wait For LOV

Allowed Child Components:

  1. Abort

  2. Abort If DataStore Is Empty

  3. Action Copy

  4. Action Download Attachment

  5. Action Group

  6. Action Search

  7. Add Breadcrumb Item

  8. Add Connection

  9. Add Smart Search Filters

  10. Change Language

  11. Choose Attachment

  12. Clear All Filters

  13. Clear All Query Params

  14. Clear All StoreRecord Messages

  15. Clear DataSource

  16. Clear Grid Sort

  17. Clear Query Param

  18. Clear Smart Search Filters

  19. Clear StoreRecord Message

  20. Confirm Message

  21. Copy StoreRecord

  22. Delete Current Record

  23. Delete Selected Records

  24. Deselect All Records

  25. Duplicate Item

  26. Duplicate StoreRecord

  27. Eval And Execute Expression

  28. Export Data

  29. Export To Google Sheet

  30. Geo Location

  31. Go Back

  32. Go To First Field

  33. Go To First Record

  34. Go To Item

  35. Go To Last Record

  36. Go To Next Record

  37. Go To Page

  38. Go To Previous Record

  39. Hide Item

  40. Hide Popup

  41. Import Data

  42. Insert Record

  43. Invoke DataSource

  44. Invoke Trigger

  45. Loop

  46. Loop Records

  47. Multi Sheet Export

  48. Open URL

  49. Print Props To Console

  50. Print To Console

  51. Query DataSource

  52. Reduce

  53. Refresh DataSource

  54. Refresh Navigation Menu

  55. Register State

  56. Remove Connection

  57. Reset DataStore

  58. Reset StoreRecord

  59. Save DataSource

  60. Save Transaction

  61. Save Video Recording

  62. Select All Records

  63. Server Validate

  64. Set As Current StoreRecord

  65. Set Data

  66. Set Message On StoreRecord

  67. Show Item

  68. Show Message

  69. Show Popup

  70. Silent Sign Out

  71. Start Video Recording

  72. Stop Video Recording

  73. Switch

  74. Update Item Number Property

  75. Update Item String Property

  76. Update StoreRecord

  77. Wait

  78. Wait For LOV

Properties

➤ Enable Condition

Specify an expression that should be evaluated to a boolean [e.g. #{dsAlias.attr1} == 'X' && #{dsAlias.attr2} > 1]. If no expression is specified, it will be considered as true.

Allowed Values: An expression which should return boolean after evaluation

➤ Target Item ID

Allowed Values: ItemID

➤ Header

Provide a header text for the downloaded file.

Allowed Values: Free text field

➤ Connection Code

Enter connection code of the Google.

Allowed Values: Free text field

➤ Google Drive Id

Enter Google drive ID where the sheet will be places.

Allowed Values: Free text field

➤ File Name

Provide a name for the downloaded file. By default, it will be downloaded with the datasource name.

Allowed Values: Provide a name for the downloaded file. By default, it will be downloaded with the datasource name.

➤ Custom Export Template Code

Specify the custom excel template code that you want to export.

Allowed Values: Free text field

PreviousExport DataNextGeo Location

Last updated