Thomson was born in Falkirk; he began his career at Celtic, joining the Glasgow giants at eight years old. In January 2012 Thomson signed a new two-year contract with the club, and was registered in the squad for the 2012-2013 UEFA Champions League campaign. However, Thomson only had two substitute appearances for the club. During his time at Celtic he spent time out on loan, firstly at Stenhousemuir in September 2012, where he made his debut against Inverness Caledonian Thistle in the League Cup, then in February 2013 at Airdrie United. His time at Airdrie United came to an end after he suffered a hand injury during a match against Dumbarton on 20 April 2013. After being released by Celtic, Thomson went on trial at Carlisle United and Oldham Athletic. Thomson signed for Rochdale on 26 July 2013, after impressing on trial. After signing, Thomson said he believed joining Rochdale "was the best move" for progressing his career. Thomson was second choice goalkeeper behind Josh Lillis for the majority of the season until he made his debut for the club against Mansfield Town on 26 December 2013, as Lillis was absent due to illness. Thomson had a shut-out as Rochdale recorded a 3–0 victory. Rochdale gained promotion to League One at the end of the 2013–14 season. Thomson also departed the club at the end of the 2013–14 season due to a lack of first team opportunities. On 18 July 2014, Thomson signed for Cowdenbeath. Thomson made his Blue Brazil debut in a 3–2 defeat against Hibernian on 13 September 2014, where his father had previously been the goalkeeping coach. He remained the first choice goalkeeper for the club throughout the season and although the club were subsequently relegated at the end of the season, Thomson was a stand out performer and earned club supporters awards for 'Player of the Season' and also ' Young Player of the Season'. Thomson signed for Queen of the South on 28 May 2015, on a two-year contract. On 31 August 2016, Thomson was released by the Dumfries club by mutual consent, after Lee Robinson's return to Queens as first choice goalkeeper. On 2 September 2016, Thomson signed for Hamilton Academical, after the club had a dilemma, with their other three goalkeepers all out injured. He left the club on 3 January 2017 and then signed for Falkirk. Thomson was released by Falkirk after the 2017–18 season. Thomson signed a two-year contract with Raith Rovers in June 2018.
Robbie attended Bantaskin Primary School and Falkirk High School. He is the son of former goalkeeper Scott Thomson who played mainly for Raith Rovers, as well as Forfar Athletic and some other clubs.