I'm going to assume you have no knowledge of scripting for posterity.
In the Creation Kit's scripting there are different "events" which, as you can tell by the name, are triggered by certain actions by the player. For what you're asking, the OnActivate event - when the player activates the object the script is attached to - will work perfectly.
The next bit are the "properties", which are - again, as the name aptly suggests - are objects the script has access to. I will touch on how to set up properties correctly later. For now, the code for adding an item when a player activates an object.
Scriptname czAddGold extends ObjectReference ;This tells the engine some stuff that isn't very important at the moment. ;If you want to learn more about what all this means, look on the wiki.
MiscObject Property czGoldCoin Auto ;Gold coins are now a property of this script.Event OnActivate(ObjectReference czUser) ;Everything between here and EndEvent will be processed when the object's activated. game.getplayer().additem(czGoldCoin, 100) ;Look familiar? This is very similar to the console command additem. ;This simply adds 100 gold coins to the player's inventory.EndEvent
I hope the code and my comments helped you understand what is going on. Now, as I said earlier, the property isn't exactly "correctly" set up with just this code attached to an object. If you ran this and used the object it's attached to it would not give you any gold. Oh no! Don't worry though, it's simple to get the desired effect. Find the object you attached the script to and then find the button that says "Properties" under add/remove script (I believe). You'll see our beautiful variable czGoldCoin all alone, with no value attached to it. Let's help a girl out (variable genders are a separate topic that need not be discussed) and click her. You'll see a drop down menu and find Gold001. There we go, now the script knows where Gold001 is and can properly give it to the player.
Again: Hope this helps! Don't hesitate to ask questions, the worst kind of coder is the one who doesn't ask any!
*When I say object it can be anything from a Standing Stone to a Dwemer Cog. Object is a general term to describe something that exists in the game.
**I wrote this all from memory. There may be some discrepancies, but hey, if you want to get into scripting (which you may not, now that I think about it

) then problem solving is the name of the game.
***Variables don't have genders. Thankfully programming isn't Romantic - I find most programmers aren't either! Zing!