How to fetch performance report of organic and direct search of website? Can we pull with api ?

[Shachi_Arkatkar]

Hey,

I'm currently facing issue with attribution of google analytics and looking at ways to pull revenue of organic search, direct and referral traffic.

The current report of organic search includes CPC and direct some times has UTMs for ads. The requirement is to get this data in sheet for multiple accounts to understand the performance improvement. 

Is their any way to pull this data in sheet or google data studio for automation of report?