Step 1 : create google sheet.
step 2 : Click on file>share>publish to web
Step 3 : Select sheet and click on publish. you will get a link.
Step 4:
Name - googl sheet
import set table name - u_google_sheet
Type - File
Format - CSV
File retrived method - HTTPS
Server - docs.google.com
File path - Copy the URL from step 3. Make sure remove the "https://docs.google.com" this from URL and paste it.
Password- do not fill.
CSV Delimiter - ,
if File path not take whole link then you should increase the "max leanght = 200". right click on "File path">configure Dictionary>Max length = 200.
Step 5 : Save the data. and click on related link "Load All Record".
Here the 2 record inserted in our staging table.
Step 6 : Now its time to create a Transform map. Click on to "Create Transform Map" link.
Step 7: click on "Auto Map Matching fields". after that you will the one field has map in the "Field Map" Related List.
Step 8 : Click on "Transform" related link.
After that you will get this screen
Step 9 : Select sys-user in right side box and click on transform button.
Step 10 : Check in User table.
Here you can see data has been map.
Additionally, you can set the Schedule import in which you can set the specific time when the transform map will get automatically transform the data into user table whenever google sheet will be updated.
Thank you. if you think this post is help you please like it.
