I will have zapier copy a source sheet to a new destination in my google drive.
After the copy, the manual process would be to click file, then share, then “publish to web”, then embed, then copy the resulting embed code.
I need to be able to do all those steps in zapier to obtain that embed code and write it to a field in another platform (tbd).
Anyone have any idea how to do this? I do not see any relevant actions within the google sheets app in zapier.