I want to push either a TSV file or JSON up to a Google Sheet
I have several large files of key/value pairs delimited by an equal sign ("="). One file is the master file. For each file, I want to populate columns A, B, and C as follows:
A: The unique key for each line in the master file
B: The value corresponding to the key in the master file.
C: The value corresponding to the same key in a secondary file.
I have no trouble converting all the files to either TSV or JSON, and I don't care which I use, because all I want to do is push it up to a Google Sheet and populate columns A, B, and C with the information described above.
I'm counting on being able to use CURL to push the data up to Google Sheets, but I'm new at this and don't know how to make it work (assuming it CAN be made to work). The goal is to have the Google Sheet for each master/secondary file pair be automatically populated as one step of a larger build job.
The sheets will be created (empty) and Published, in advance of the build, so that the URL of the Sheet can be made available to the build job.
The specific use is to supply text prompts for application forms in multiple languages. Column A is the key, B is the English, C is the target language. There will be a separate Sheet for each target language. This scheme is to facilitate translation efforts. We've been doing this for years, but always by hand. The goal is to automate the process.
Any and all advice and instruction will be gratefully received. Thank you.
ubuntu csv curl google-spreadsheets json
asked Feb 7 at 9:30
Brice BuchananBrice Buchanan
62
add a comment |
I have several large files of key/value pairs delimited by an equal sign ("="). One file is the master file. For each file, I want to populate columns A, B, and C as follows:
A: The unique key for each line in the master file
B: The value corresponding to the key in the master file.
C: The value corresponding to the same key in a secondary file.
I have no trouble converting all the files to either TSV or JSON, and I don't care which I use, because all I want to do is push it up to a Google Sheet and populate columns A, B, and C with the information described above.
I'm counting on being able to use CURL to push the data up to Google Sheets, but I'm new at this and don't know how to make it work (assuming it CAN be made to work). The goal is to have the Google Sheet for each master/secondary file pair be automatically populated as one step of a larger build job.
The sheets will be created (empty) and Published, in advance of the build, so that the URL of the Sheet can be made available to the build job.
The specific use is to supply text prompts for application forms in multiple languages. Column A is the key, B is the English, C is the target language. There will be a separate Sheet for each target language. This scheme is to facilitate translation efforts. We've been doing this for years, but always by hand. The goal is to automate the process.
Any and all advice and instruction will be gratefully received. Thank you.
ubuntu csv curl google-spreadsheets json
asked Feb 7 at 9:30
Brice BuchananBrice Buchanan
62
add a comment |
I have several large files of key/value pairs delimited by an equal sign ("="). One file is the master file. For each file, I want to populate columns A, B, and C as follows:
A: The unique key for each line in the master file
B: The value corresponding to the key in the master file.
C: The value corresponding to the same key in a secondary file.
I have no trouble converting all the files to either TSV or JSON, and I don't care which I use, because all I want to do is push it up to a Google Sheet and populate columns A, B, and C with the information described above.
I'm counting on being able to use CURL to push the data up to Google Sheets, but I'm new at this and don't know how to make it work (assuming it CAN be made to work). The goal is to have the Google Sheet for each master/secondary file pair be automatically populated as one step of a larger build job.
The sheets will be created (empty) and Published, in advance of the build, so that the URL of the Sheet can be made available to the build job.
The specific use is to supply text prompts for application forms in multiple languages. Column A is the key, B is the English, C is the target language. There will be a separate Sheet for each target language. This scheme is to facilitate translation efforts. We've been doing this for years, but always by hand. The goal is to automate the process.
Any and all advice and instruction will be gratefully received. Thank you.
ubuntu csv curl google-spreadsheets json
asked Feb 7 at 9:30
Brice BuchananBrice Buchanan
62
I have several large files of key/value pairs delimited by an equal sign ("="). One file is the master file. For each file, I want to populate columns A, B, and C as follows:
A: The unique key for each line in the master file
B: The value corresponding to the key in the master file.
C: The value corresponding to the same key in a secondary file.
I have no trouble converting all the files to either TSV or JSON, and I don't care which I use, because all I want to do is push it up to a Google Sheet and populate columns A, B, and C with the information described above.
I'm counting on being able to use CURL to push the data up to Google Sheets, but I'm new at this and don't know how to make it work (assuming it CAN be made to work). The goal is to have the Google Sheet for each master/secondary file pair be automatically populated as one step of a larger build job.
The sheets will be created (empty) and Published, in advance of the build, so that the URL of the Sheet can be made available to the build job.
The specific use is to supply text prompts for application forms in multiple languages. Column A is the key, B is the English, C is the target language. There will be a separate Sheet for each target language. This scheme is to facilitate translation efforts. We've been doing this for years, but always by hand. The goal is to automate the process.
Any and all advice and instruction will be gratefully received. Thank you.
ubuntu csv curl google-spreadsheets json
ubuntu csv curl google-spreadsheets json
asked Feb 7 at 9:30
Brice BuchananBrice Buchanan
62
asked Feb 7 at 9:30
Brice BuchananBrice Buchanan
62
asked Feb 7 at 9:30
Brice BuchananBrice Buchanan
62
asked Feb 7 at 9:30
Brice BuchananBrice Buchanan
62
asked Feb 7 at 9:30
Brice BuchananBrice Buchanan
62
62
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1403048%2fi-want-to-push-either-a-tsv-file-or-json-up-to-a-google-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1403048%2fi-want-to-push-either-a-tsv-file-or-json-up-to-a-google-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
