I had been waiting since April to have a gastroscopy and like everyone else had been getting increasingly anxious about the procedure and desperately scrolling for positive experiences amongst all the stories of how bad it would be. 
I had my procedure this morning and it was an absolute breeze. The worst part most definitely was waiting for my turn to be called. 
There was never any doubt for me that I would opt for both throat spray and sedation. I'm not brave and was extremely scared. The throat spray was fine. Bitter banana taste that slightly burns your oesophagus (ironic since heartburn was one of my main symptoms). Then there was a weird numbing feeling starting on my tongue and working backwards through my mouth. I'd read about people feeling like they couldn't breathe and the consultant had also explained about that so I was prepared and didn't feel it was a problem. I also had oxygen in my nose so maybe that helped too.

There was a bit of difficulty finding veins for the cannula so I was a little worried they might be unable to sedate me, but fortunately at the fourth attempt one appeared and it was fine.  The mouth guard was put in and I was ready.

After a few minutes to allow the sedation to work we were off and the part I was dreading most was coming - swallowing the tube. It was easy. I felt it coming towards the back of my mouth and with a couple of swallows (which I couldn't really feel as I was numb) it was down. No gagging, no coughing, no retching.  I had been told the best thing I could do was focus on deep, regular breathing so that's what I did.  I was aware all the time of something in my mouth and I felt the tube being removed but that was it. And it felt like it was all over in about 2 mins (probably took 5-6).

Then back in the recovery room until the throat spray wore off, then something to eat and drink and I could be collected.  I'm home now and feel a bit tired (but that could be more about lack of sleep due to worry) but otherwise fine.

I'm sorry for such a long post but before my procedure I was really worried and desperate to hear blow-by-blow accounts from people who hadn't had terrible experiences and might be able to calm my nerves. I hope this helps anyone else about to go through it.  You'll be scared, naturally, and I know everyone has different tolerance levels but unless you're one of the unlucky ones I just want to say it's really not that bad.