Ministers said offshore wind farms had the potential to create tens of thousands of jobs but the figure was only 1700 in 2018.
Trade unions have blasted the SNP Government after only a fraction of the green jobs heralded by ministers were created.
Deputy First Minister John Swinney said in 2010 that offshore wind energy could create 28,000 posts by this year.
However, Unite Scottish Secretary Pat Rafferty said the figure had been a “pipe dream”, with there only being 1700 jobs in 2018.
Gary Smith, Scotland Organiser of the GMB, also complained about jobs being shipped overseas.
The Government has championed renewables, with former First Minister Alex Salmond once claiming the Pentland Firth could be the “Saudi Arabia of marine power”.
when he was Finance Secretary nine years ago, published a document on how a “low carbon economic strategy” could benefit the country.
The document talked up offshore wind and said: “This sector alone offers the potential for 28,000 direct jobs and a further 20,000 jobs in related industries and £7.1 billion investment in Scotland by 2020.”
Critics believe there is a huge gap between the rhetoric of a renewable energy boom and the reality.
Using freedom of information legislation, Unite asked the Government about jobs created in the offshore wind sector.
Citing estimates from the Office for National Statistics, the Government said there were around 700 jobs in 2014 and 400 in the following year.
The total jumped to 1200 in 2016, rose again to 2,000 twelve months later, but fell back to 1,700 in 2018.
The government added that these figures were “extrapolated from a survey” and “subject to margins of error”.
Rafferty hit out: “The latest data by the ONS highlights that direct employment is around 1,700 jobs when a green jobs bonanza of 28,000 was promised 10 years ago by the Scottish Government.
“We now have definite proof that this has been a pipe dream. Billions of pounds worth of renewables contracts are being awarded with minimal benefits to local and regional supply chains which is why urgent action must be taken.”
Scotland also missed out on hundreds of millions of pounds of work to foreign firms through the £2b Neart Na Gaoithe offshore wind farm.
It later emerged that the Seagreen project, which could create more than 400 jobs annually, was looking to China.
Smith said: “Nearly 12 years on from Alex Salmond’s infamous ‘Saudia Arabia of renewables’ claim, we can say with certainty that there is no green jobs revolution in Scotland.
“The truth is that when it comes to offshore wind the Scottish Government and the renewables industry body are stronger for China, Indonesia and the UAE – anywhere but Scotland.
A Scottish Government spokesperson said: “The report, published a decade ago, included a range of possible scenarios based on robust industry data available at that time – a time when the support mechanism for offshore wind looked very different to now.
“UK Government policy has undermined the ability of offshore wind developers to utilise the local supply chain, because its focus is on price alone, rather than taking into account value created for the economy.
“For our part, we are using all devolved powers at our disposal to maximise economic and jobs potential from Scotland’s enormous renewable energy resources – which will be vital to meeting both Scotland’s and the UK’s net zero emissions targets.”