Forum Discussion

ScottTalarico's avatar
ScottTalarico
Qrew Cadet
11 months ago

Pipeline Upload gsheet to google doc

I'm using Buckets to create a table and download a CSV.  When I upload it to the google drive it's errors out if I make the Mime Type a Google Sheet.  If I don't specify the Mime Type the file can't be read in the Google Drive.  I can load the file from bucket step manually and convert it in the Google Drive manually to a gsheet so it doesn't seem the file itself.  I have also tried adding the gheet extension and that doesn't help either.   



------------------------------
Scott Talarico
------------------------------
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    11 months ago

    What's the error you're getting?  I'm doing this also and it works for me.  The pipeline looks like this:



    ------------------------------
    Jeff Peterson
    ------------------------------
    • ScottTalarico's avatar
      ScottTalarico
      Qrew Cadet
      11 months ago

      I have the same setup with the exception my trigger is daily.  I get a "Remote service reported an error: Bad Request" error.  This is when I use the Mime Type as a gsheet.  I have tried this booth with just the file name and also the FileName.gsheet.  



      ------------------------------
      Scott Talarico
      ------------------------------