Append row to Google Spreadsheet

[mr.ga...@gmail.com]

Hi,

Has anyone come across a way to append a line of text to Google Docs/Spreadsheet?
The lack of which has resulted my flow having to
(1) Download the whole document from Google
(2) Append a line to that file
(3) Upload the modified document

As you can imagine over time as my file size increases this Download/Upload business is going to be slow and costly.

[Henrik "The Developer" Lindqvist]

Either call the Google Spreadsheet API directly with OAuth2 authentication:
https://developers.google.com/sheets/
http://llamalab.com/automate/community/flows/3280

Or via form submission using Google Apps Script:
https://mashe.hawksey.info/2014/07/google-sheets-as-a-database-insert-with-apps-script-using-postget-methods-with-ajax-example/
https://github.com/dwyl/html-form-send-email-via-google-script-without-server

[Automate user]

Thanks for the quick response. I found writing a Google Apps Script that receives JSON data works for me.
Here's a link for anybody else wanting to receive post data  https://developers.google.com/apps-script/guides/web

[Wojtek Kuncewicz]

Hello,

I found another solution to update Google Spreadsheets.

1. Plugin from tasker: 

https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin&hl=pl

2. curl via google forms -> google spreadsheet for example:

curl -k https://docs.google.com/forms/d/e/%FORM_NUMBER%/formResponse -d ifq -d entry.%FIRST%=%VALUE1% -d entry.%SECOND%=%VALUE2% -d submit=Submit

%FORM_NUMBER% - google form id

%FIRST% - 1st field-name

%VALUE1% - 1st field-value

etc

3. Via culr with Google API

curl -k 'https://sheets.googleapis.com/v4/spreadsheets/%SPREADSHEET_ID%?access_token=%TOKEN_ID%'

%SPREADSHEET_ID% - google spreadsheet id number

%TOKEN_ID% - token from google api like  'ya29.Glv0A-bZjCzads[...]'

Is there any others solution for updating google spreadsheets with variables from automate?

[Henrik "The Developer" Lindqvist]

How many more solutions to you need, doesn't three suffice?

[Automate user]

Ahh nice one Wojtek. Google forms never crossed my mind. Well done :)

[Wojtek Kuncewicz]

yes, its ok but I was thinking sth like... function in automate like 'gmail send' or 'google drive upload'.

I would like to use function instead of alternatives tools for example curl. It would be easier i think.

[Henrik "The Developer" Lindqvist]

It's already on the to-do list. But there's so many APIs, making a custom block for each and every one has low priority.

[freddix...@gmail.com]

sorry to bring this up again. the spreadsheettasker plugin is having much difficulty updating the spreadsheet. 

so i found a tasker method to post to a google forms and have been trying to convert to automate [link here] and have gotten stuck on how to populate the block with the data.

I get an error , essentially a syntax error i guess trying to set the for variable to my data variable ie [entry.548313995 = %mydata1, entry.1410521298= %mydata2}. the error doesnt like the "."

I figured if it could work in tasker I could make it work, but as i said im stuck.