# Trouble exporting to google sheets

**URL:** <https://forum.getodk.org/t/trouble-exporting-to-google-sheets/4314>\
**Category:** Support\
**Created:** [May 10, 2015, 7:00pm UTC](https://forum.getodk.org/t/trouble-exporting-to-google-sheets/4314 "2015-05-10T19:00:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bill\_Olander](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/b/a587f6/32.png) [@Bill\_Olander](https://forum.getodk.org/u/Bill_Olander)\
**Post date:** [May 10, 2015, 7:00pm UTC](https://forum.getodk.org/t/trouble-exporting-to-google-sheets/4314/1 "2015-05-10T19:00:53Z")

</div>

Hi all,  
I'm able to publish to google fusion tables but encounter the error  
message below when trying to publish to google sheets. When following the  
instruction for setting up the API and credentials there was no option to  
select google sheets as an API. I have verified that the google drive API  
is enabled.  
Any idea what I'm doing wrong:

Error: RequestFailureException  
(com.google.gdata.util.InvalidEntryException: The Doclist API has been shut  
down. Please use the new Drive API, [https://developers.google.com/drive/](https://developers.google.com/drive/).  
GData`BadRequestException`The  
Doclist API has been shut down. Please use the new Drive API,  
[https://developers.google.com/drive/.](https://developers.google.com/drive/.) )

Thanks!  
Bill

---

<div class="post-metadata">

**Author:** ![Mitch\_S](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/3ec8ea/32.png) [@Mitch\_S](https://forum.getodk.org/u/Mitch_S)\
**Post date:** [May 11, 2015, 4:23pm UTC](https://forum.getodk.org/t/trouble-exporting-to-google-sheets/4314/2 "2015-05-11T16:23:56Z")

</div>

You need to upgrade to ODK Aggregate 1.4.7.

This issue was detected after the April 20th shut-off of numerous Google  
functionality, and was fixed in ODK Aggregate 1.4.6.

> **···**
>
> On Sun, May 10, 2015 at 12:00 PM, Bill Olander wrote:
> 
> > Hi all,  
> > I'm able to publish to google fusion tables but encounter the error  
> > message below when trying to publish to google sheets. When following the  
> > instruction for setting up the API and credentials there was no option to  
> > select google sheets as an API. I have verified that the google drive API  
> > is enabled.  
> > Any idea what I'm doing wrong:
> > 
> > Error: RequestFailureException  
> > (com.google.gdata.util.InvalidEntryException: The Doclist API has been shut  
> > down. Please use the new Drive API, [https://developers.google.com/drive/](https://developers.google.com/drive/).  
> > GData`BadRequestException`The  
> > Doclist API has been shut down. Please use the new Drive API,  
> > [https://developers.google.com/drive/.](https://developers.google.com/drive/.) )
> > 
> > Thanks!  
> > Bill
> > 
> > ## --
> > 
> > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)  
> > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com)  
> > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en)
> > 
> > * * *
> > 
> > You received this message because you are subscribed to the Google Groups  
> > "ODK Community" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> 
> --  
> Mitch Sundt  
> Software Engineer  
> University of Washington  
> [mitchellsundt@gmail.com](mailto:mitchellsundt@gmail.com)