Hi,
I am a newbie and I need your help.
I use Tally as first element.
Informations from Tally are transfered directly to a google sheets. Some of them are used to calculate new data (for instance, in cell C24).
I wish to export this new data (cell C24) in google doc with a prepared template.
After that, a PDF will be sent.
Could you please help me?
Hey @Cherriere
Welcome to the Make Community.
Can you please share your scenario blueprint by exporting it.
Thanks,
Sachin Shrivastava
growwstacks.com
Welcome to the Make community!
You can extract the updated cell value from the spreadsheet by using the “Get a Cell” module.
Here are some useful links and guides to help you get started and learn more on how to use the Make platform, apps, and app modules —
parseDate | Tokens for formatDateHere you are !
blueprint.json (71.4 KB)
Hi, thanks for your message.
I already tried, but I cannot find the new doc (after the step “create a spreadsheet from a template”) as it does not exist yet.
Do you have any idea?
You can map the File ID from the “Create a spreadsheet from a template” module into the "Get a Cell” module.
If you need further assistance,
Please provide the output bundles of the “Create a spreadsheet from a template” module by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.
Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
Uploading it here will look like this:
bundle.txt (12.3 KB)
If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:
Either add three backticks ``` before and after the code, like this:
```
input/output bundle content goes here
```
Or use the format code button in the editor:
Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
This will allow others to better assist you. Thanks!
{
"kind": "drive#file",
"id": "1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4",
"name": "Simu scpi cash test test test",
"mimeType": "application/vnd.google-apps.spreadsheet",
"starred": false,
"trashed": false,
"explicitlyTrashed": false,
"parents": [
"1XtF0Brfgr50tWcIvILmOhFsS40CbQeVr"
],
"spaces": [
"drive"
],
"version": "3",
"webViewLink": "https://docs.google.com/spreadsheets/d/1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4/edit?usp=drivesdk",
"iconLink": "https://drive-thirdparty.googleusercontent.com/16/type/application/vnd.google-apps.spreadsheet",
"hasThumbnail": false,
"thumbnailVersion": "0",
"viewedByMe": true,
"viewedByMeTime": "2024-01-08T12:51:54.801Z",
"createdTime": "2024-01-08T14:13:31.189Z",
"modifiedTime": "2024-01-08T14:13:31.189Z",
"modifiedByMeTime": "2024-01-08T14:13:31.189Z",
"modifiedByMe": true,
"owners": [
{
"kind": "drive#user",
"displayName": "Pierre Cherriere",
"photoLink": "https://lh3.googleusercontent.com/a/ACg8ocJBmcMf6Xsep40iuhwNuDdEpII7dKaYas6AoNB1cHIT=s64",
"me": true,
"permissionId": "07066178128086414718",
"emailAddress": "pjcherriere@gmail.com"
}
],
"lastModifyingUser": {
"kind": "drive#user",
"displayName": "Pierre Cherriere",
"photoLink": "https://lh3.googleusercontent.com/a/ACg8ocJBmcMf6Xsep40iuhwNuDdEpII7dKaYas6AoNB1cHIT=s64",
"me": true,
"permissionId": "07066178128086414718",
"emailAddress": "pjcherriere@gmail.com"
},
"shared": false,
"ownedByMe": true,
"capabilities": {
"canAcceptOwnership": false,
"canAddChildren": false,
"canAddMyDriveParent": false,
"canChangeCopyRequiresWriterPermission": true,
"canChangeSecurityUpdateEnabled": false,
"canChangeViewersCanCopyContent": true,
"canComment": true,
"canCopy": true,
"canDelete": true,
"canDownload": true,
"canEdit": true,
"canListChildren": false,
"canModifyContent": true,
"canModifyContentRestriction": true,
"canModifyEditorContentRestriction": true,
"canModifyOwnerContentRestriction": true,
"canModifyLabels": false,
"canMoveChildrenWithinDrive": false,
"canMoveItemIntoTeamDrive": true,
"canMoveItemOutOfDrive": true,
"canMoveItemWithinDrive": true,
"canReadLabels": false,
"canReadRevisions": true,
"canRemoveChildren": false,
"canRemoveContentRestriction": false,
"canRemoveMyDriveParent": true,
"canRename": true,
"canShare": true,
"canTrash": true,
"canUntrash": true
},
"viewersCanCopyContent": true,
"copyRequiresWriterPermission": false,
"writersCanShare": true,
"permissions": [
{
"kind": "drive#permission",
"id": "07066178128086414718",
"type": "user",
"emailAddress": "pjcherriere@gmail.com",
"role": "owner",
"displayName": "Pierre Cherriere",
"photoLink": "https://lh3.googleusercontent.com/a/ACg8ocJBmcMf6Xsep40iuhwNuDdEpII7dKaYas6AoNB1cHIT=s64",
"deleted": false,
"pendingOwner": false
}
],
"permissionIds": [
"07066178128086414718"
],
"size": "1",
"quotaBytesUsed": "1",
"isAppAuthorized": true,
"exportLinks": {
"application/x-vnd.oasis.opendocument.spreadsheet": "https://docs.google.com/spreadsheets/export?id=1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4&exportFormat=ods",
"text/tab-separated-values": "https://docs.google.com/spreadsheets/export?id=1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4&exportFormat=tsv",
"application/pdf": "https://docs.google.com/spreadsheets/export?id=1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4&exportFormat=pdf",
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet": "https://docs.google.com/spreadsheets/export?id=1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4&exportFormat=xlsx",
"text/csv": "https://docs.google.com/spreadsheets/export?id=1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4&exportFormat=csv",
"application/zip": "https://docs.google.com/spreadsheets/export?id=1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4&exportFormat=zip",
"application/vnd.oasis.opendocument.spreadsheet": "https://docs.google.com/spreadsheets/export?id=1i3MISWvxvupBYJM6opLGA4kgYH7y_23d0eKAuzTZbI4&exportFormat=ods"
},
"linkShareMetadata": {
"securityUpdateEligible": false,
"securityUpdateEnabled": true
}
Map this into your "Get a Cell” module.
Re @samliew
It works one time only.
Indeed, when I receive a new tally form, the id changes.
Therefore, it’s always the same number in google doc C24